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: Unusable index in Partitioned table

Re: Unusable index in Partitioned table

From: bocgco <bocgco_at_bocgco.com>
Date: Fri, 23 May 2003 11:43:27 +0800
Message-ID: <3ecd9889$1@shknews01> 





Problem found, when there are subpartitions and some of the subpartitions'
index are valid while some are unusable, the optimatizer will treat it as
"usuable".  However, when the enquery hits the unusable index, the problem
will arise even "alter session set skip_unusable_index=true"
Received on Thu May 22 2003 - 22:43:27 CDT












Original text of this message













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