Hey... As far as my knowledge is, the tables should be joint first followed by the restiction. check it out.
Regards, Twii On 11/10/08, weird0 <[EMAIL PROTECTED]> wrote: > > > Would be it a more optimizable sol. to apply the joining conditions > first or apply the restrictions on fields like male gender. > > I believe applying the restrictions first, to min. the table and then > to join the tables is more optimized way. > > For example:- > > More optimized > -------------------- > > select a.col1,b.col1,c.col1 > from tbl_1 a, tbl_2 b, tbl_3 c > where a.gender='Male' > and a.type='Animal' > and a.id=b.id > and a.id=c.id > > Less optimized > ---------------------- > select a.col1,b.col1,c.col1 > from tbl_1 a, tbl_2 b, tbl_3 c > where a.id=b.id > and a.id=c.id > and a.gender='Male' > and a.type='Animal' > > Kindly, respond and give me refer me additional comprehensive good > links about > Query Optimizations. > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
