RE: Need help on query performance issue

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 
 


________________________________

        From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
        
        Reg,
        An
        
        
        On Thu, Oct 1, 2009 at 3:04 PM, Balakrishna Y
<krishna000@xxxxxxxxx> wrote:
        

                Hi,
                 
                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 .
                 
                Regards
                 
                Bala 
                
                 
                On 10/1/09, Shastry(DBA) <shastry17@xxxxxxxxx> 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.
                        
                        Reg,
                        An

Other related posts: