Help - Search - Members - Calendar
Full Version: Subqueries versus joins
Oracle DBA Forums > Oracle > Oracle Forum
testoracle
If the requirement can be fulfilled by using either of the subqueries and inner joins, What is the best approach?
burleson
>> 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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.