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

Home -> Community -> Mailing Lists -> Oracle-L -> Local Prefix vs non-prefix indexes

Local Prefix vs non-prefix indexes

From: Cale, Rick T (Richard) <RICHARD.T.CALE_at_saic.com>
Date: Wed, 29 Nov 2000 06:03:36 -0800
Message-Id: <10695.123185@fatcity.com> 





I was reading about partitioning and it states the following:



"Local nonprefixed indexes provide more availability than prefixed indexes
when partition


maintenance operations are carried out."



Can someone explain WHY?



Thanks


Rick Cale, Science Applications International Corp.
Phone:865-481-2198, fax:865-481-8555


e-mail: caler_at_saic.com
Received on Wed Nov 29 2000 - 08:03:36 CST












Original text of this message













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