Hello Oracle Experts,
I have two tables one is TAB1 (1000 rows) and other one is TAB2 (10 rows) now select tab1.*,tab2.* from TAB1 ,TAB2 where (tab1.col=tab2.col);
select tab1.*,tab2.* from TAB2 ,TAB1 where (tab2.col=tab1.col);
In these both two query's which one is most efficient?
Please have a look in to the matter and advice me the right one so that I can work further as per the best.
Thank You in Advance!