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 -> Re: Unique index not being used, up to date stats

Re: Unique index not being used, up to date stats

From: Valentin Minzatu <valentinminzatu_at_yahoo.com>
Date: 29 Jan 2007 12:59:26 -0800
Message-ID: <1170104366.325708.111280@p10g2000cwp.googlegroups.com> 





It looks like you have 3 options:


1. open a case with Oracle


2. keep replacing statistics with the old values (I know in 10g you 
can lock statistics, but I do not know of any method for doing it in 
9i)


3. use stored outlines
Received on Mon Jan 29 2007 - 14:59:26 CST












Original text of this message













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