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 does CBO handle old statistics

how does CBO handle old statistics

From: Ben <balvey_at_comcast.net>
Date: 9 Mar 2006 15:28:57 -0800
Message-ID: <1141946937.633252.222600@p10g2000cwp.googlegroups.com> 





I've got a smallish 9.2.0.5 db that hasn't been analyzed since April
2004. How does the cost based optimizer handle old statistics? Would it
ignore and default to rule based or just use the old stats?
Received on Thu Mar 09 2006 - 17:28:57 CST












Original text of this message













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