RE: ** simulate explain plan

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Mon, 25 Feb 2008 09:35:16 -0500
Message-ID: <D1DC33E67722D54A93F05F702C99E2A901FE14D4@usahm208.amer.corp.eds.com>


1 - Did you re-generate the statistics on both systems using the same parameters and values  

2 - After updating the statistics did you compare the dba_tab_columns values to see if the data distribution could be different. This can be very important if histograms (the default on 10g+) are generated and come into play for the query in question  

  • Mark D Powell -- Phone (313) 592-5148

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Finn Jorgensen

	Sent: Sunday, February 24, 2008 10:47 PM
	To: ajoshi977_at_yahoo.com
	Cc: oracle-l_at_freelists.org
	Subject: Re: ** simulate explain plan
	
	
	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/newsear ch/category.php?category=shopping>                                  

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 25 2008 - 08:35:16 CST

Original text of this message