No it's not pretty straight forward. It's not going to do 19*76570 . These records will be processed now according to the condition and i do not think you can calculate how many number of records returned by nested loop as simple as that.