Why Oracle not choosing proper plan
Hello All,
Could some body help me on this?
There is very little difference between first and second queries joins. Last join , which is commented in the first case, is added and an extra join and that join is not actually required. After adding that extra condition now the query is ver very quick . I want to understand why we had to add that extra join at all. I can't understand this. Could some body help me.. this is little urgent for me .. thanks for your time.
Query One:
SELECT COUNT(*)
FROM cris.tra t, dcsw_owner.pec_acc_local p
There is very little difference between first and second queries joins. Last join , which is commented in the first case, is added and an extra join and that join is not actually required. After adding that extra condition now the query is ver very quick . I want to understand why we had to add that extra join at all. I can't understand this. Could some body help me.. this is little urgent for me .. thanks for your time.
Query One:
SELECT COUNT(*)
FROM cris.tra t, dcsw_owner.pec_acc_local p
0