Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How do you un-analyze tables?

How do you un-analyze tables?

From: George Barbour <george.barbour_at_gecm.com>
Date: Thu, 28 Jun 2001 14:17:07 +0100
Message-ID: <3b3b2c17$1@pull.gecm.com> 






Hi all,


Oracle 8.1.5.


Sun Solaris Unix 2.8.


The situation, I have many Oracle Discoverer queries against the database.
 Some queries run as RULE and some ran as COST.
I analyzed the objects, mistake! Now all of the queries run as COST. The
difference in run time is spectacular.


Rule based = 17.9 secs.


Cost based = 388 mins.



    
  
  1.   How to I un-analyze objects, to get back to where I was before?
  
  2.   Why doesn't the system use the blatantly faster optimisation mode?






George Barbour.


.
Received on Thu Jun 28 2001 - 08:17:07 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US