RE: Need help on query performance issue

From: Powell, Mark D <>
Date: Thu, 1 Oct 2009 10:39:25 -0400
Message-ID: <>

Why is the Optimizer Mode=FIRST_ROWS? I this the production setting also?  

Where is the production explain plan for comparison purposes?  

What happens to the plan which is using a lot of full table scans since it is using hash joins if you change the optimizer mode to ALL_ROWS?    

  • Mark D Powell -- HP Enterprise Services Phone (313) 592-5148

[] On Behalf Of Shastry(DBA)

	Sent: Thursday, October 01, 2009 9:35 AM
	To: oracle-l
	Cc: Balakrishna Y
	Subject: Re: Need help on query performance issue
	Hi All/Balakrishna,
	Thanks for notifying it. Please find attached my explain plan
and the SQL script. Please help.         
	On Thu, Oct 1, 2009 at 3:04 PM, Balakrishna Y
<> wrote:         


                There is no evidence for your question at all .... just post you query and statistics of your table & indexes ...                  

                Only then some one can help you out in this .                  



                On 10/1/09, Shastry(DBA) <> wrote:

			Hi Gurus,
			I have Oracle query which runs fine in
production and test1 server but taking more time in the recently cloned two more dev servers. i checked for explain plan and got that two tables are having FULL TABLE SCANS and didnt find anything FTS issue in production and test1 servers with the same data. I did analyze two databases completely to have latest stats collection but didnt help :(.
			How to tackle this issue please guide.
			Thanks in advance.

Received on Thu Oct 01 2009 - 09:39:25 CDT

Original text of this message