testoracle
Aug 4 2008, 05:57 AM
If the requirement can be fulfilled by using either of the subqueries and inner joins, What is the best approach?
burleson
Aug 4 2008, 07:51 AM
>> If the requirement can be fulfilled by using either of the subqueries and inner joins, What is the best approach?
Whenever possible, replace subqueries with joins! (It's not always possible!).
See here for details:
http://www.dba-oracle.com/t_tuning_sql_subqueries.htm