Re: SQL problem
Posted by:
Bob Field
Date: September 01, 2006 11:49AM
A left join implies retrieving all rows from the lefthand table in the join, therefore no index would be used since a full table scan is already mandated, and opening an index would only incur extra overhead.
Subject
Views
Written By
Posted
2883
September 01, 2006 11:26AM
Re: SQL problem
1508
September 01, 2006 11:49AM
1560
September 02, 2006 03:13AM
1705
October 04, 2006 11:49AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.