Re: ** simulate explain plan

From: Finn Jorgensen <>
Date: Sun, 24 Feb 2008 22:47:00 -0500
Message-ID: <>

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


On Sun, Feb 24, 2008 at 9:33 PM, A Joshi <> 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.<*>

Received on Sun Feb 24 2008 - 21:47:00 CST

Original text of this message