-
Reverse Key indexes
Can't understand the point in a reverse key index at the end of the day. Yes i cna see some advantages in that the B-tree index will be more evenly balanced when indexing on a column with sequential values. But then to go and reverse the values surely this counters the whole point of indexes in that it scatters the sequential values so that 2 sequential values will end up in different branches when if they hadn't been reversed they would have been found more quickly since they would be on the same branch.
Has anyone used RKIs to their advantage?
Cheers
Gus
Again!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|