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 [email protected] 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 -~----------~----~----~----~------~----~------~--~---
