Hi everyone!
I have some sqls which look like this
select ...
from table A, table B
where a.name = b.name
and a.name in (....)
Now, which one of this is executed first? the where clause or the and clause?
Joining the tables is preferably done in where clause?
I am using Oracle 10g.
Please give me some guidance.
Thank You.
Nith