Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: reverse indexes
They work real well for PK's that are based off sequances. It allows
for a BTree index to be build better. But that is about the only real
use. I would always suggest using them if your PK is going up 1 at a
time.
Another good hint for index speed is to make the PK's start high, like 1000 if you will have 5000 rows or so, this way they all will be in the tree nicely.
Questions, just ask. Feel free to email, but make sure to post in group as well. I will only answer the post in the group, but I may miss it unless I get an email.
Chris
--Any information give by me might be my opion, please do not hold anything read here are direct fact, use information at your own risk. Received on Thu Apr 25 2002 - 15:31:50 CDT