Re: ** simulate explain plan

From: Finn Jorgensen <finn.oracledba_at_gmail.com>
Date: Sun, 24 Feb 2008 22:47:00 -0500
Message-ID: <74f79c6b0802241947o72777ec1l2613da17c46dad9d@mail.gmail.com>


The hint you're looking for is "ordered".

Finn

On Sun, Feb 24, 2008 at 9:33 PM, A Joshi <ajoshi977_at_yahoo.com> wrote:

> * resending with subject *
> Hi,
> I have query joining 8 tables running fine in one env but a little
> slow on another. The indexes are same and there. Most of the plan is same
> and index usage is same. There is difference in order in explain plan as one
> table is accessed at a different order. I tried usual use_nl and other hints
> but cannot seem to sync up the explain plan. Any tricks to alter the
> plan/order to syncup. Or get a hint to simulate the explain plan. I am on
> 9i. Thanks
>
> ------------------------------
> Looking for last minute shopping deals? Find them fast with Yahoo! Search.<http://us.rd.yahoo.com/evt=51734/*http://tools.search.yahoo.com/newsearch/category.php?category=shopping>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Feb 24 2008 - 21:47:00 CST

Original text of this message