**
- From: A Joshi <ajoshi977@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sun, 24 Feb 2008 17:21:43 -0800 (PST)
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
---------------------------------
Never miss a thing. Make Yahoo your homepage.
Other related posts:
