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 -> What type of index is best for a large partitioned table?

What type of index is best for a large partitioned table?

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Sun, 23 Jul 2006 14:14:00 GMT
Message-ID: <IuLwg.71207$Lm5.37788@newssvr12.news.prodigy.com> 





What type of index is best for a large partitioned table of about 69 million
rows?



A global partitioned index or local partitioned index?  Or do we need both
types?



Thanks.
Received on Sun Jul 23 2006 - 09:14:00 CDT












Original text of this message













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