Re: single sweep multi join in combination with where
Posted by:
Rick James
Date: August 31, 2008 11:57PM
1. See if you get any clues from EXPLAIN EXTENDED.
2. Probably no difference, since the optimizer will realize that your queries are equivalent. I think it will do the optimal thing in both cases.
Subject
Views
Written By
Posted
5754
July 27, 2008 07:03AM
Re: single sweep multi join in combination with where
2335
August 31, 2008 11:57PM
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.