sql query tuning

[abhaysk]

Originally posted by adewri
The plan is changing because in the first querry you have used

AND (tptfbdr_a.codptf = 'CROSB')

and in the next

AND (tptfbdr_b.codptf = 'WARTS')

Not Necessarly it should change.