January 15, 2004 at 9:01 am
Does SQL Server have anything similar to the key compressed index in Oracle?
January 19, 2004 at 8:00 am
This was removed by the editor as SPAM
March 3, 2004 at 10:59 am
As far as I know, there is no equivelent index switch for SQL Server that would accomplish this. It's a nice Oracle feature, and I wish I could use it on SQL Server, but I don't think it's possible.
Ryan
March 3, 2004 at 4:27 pm
(admittedly Oracle ignorant) can you explain what a Key compressed index is?
------------
Ray Higdon MCSE, MCDBA, CCNA
March 3, 2004 at 4:43 pm
In short, it "enables you to eliminate repeated occurrences of key column prefix values". I've not used it before, I've only read about it, but when you have a concatenated key for an index, it allows you to eliminate repeated copies of the index key when large parts of the index can be reoccuring. Although there is a space savings by compressing the index, there can be a higher CPU cost, since the index is more complex to construct. Also, there is a possibility that your disk I/O will be lowered, especially on a larger index, since fewer physical blocks have to be read to load the index into memory.
Ryan
March 3, 2004 at 5:09 pm
Thanks, Interesting, can't immediately think of a pretty way to do this in SQL Server.
------------
Ray Higdon MCSE, MCDBA, CCNA
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply