Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> reverse indexes
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