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 -> reverse indexes

reverse indexes

From: Richard Kuhler <noone_at_nowhere.com>
Date: Wed, 24 Apr 2002 23:56:24 GMT
Message-ID: <ICHx8.63745$zN.32265781@twister.socal.rr.com>


The Oracle documentation suggests possibly using 'reverse key indexes' to prevent serialization with monotonically growing values. I see that you can't perform range scans with them but are there other disadvantages to using them? Anyone have any experience using them for primary keys on large tables (>10 million rows)? Are there other factors that may influence occasionally rebuilding the index still?

Thanks,
Richard Received on Wed Apr 24 2002 - 18:56:24 CDT

Original text of this message

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