Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Index key compression
Has anyone used the index key compression feature in Oracle 8i? Seems like a nice optimization. I would expect most indexes to see a substantial reduction in storage because of this.
Sounds nice in theory, but any hidden gotchas, pitfalls? Performance issues? Bugs?
Getting into the internals of it, is this still a b*tree index? How does Oracle do the compression? Store pointers to other rows with these keys in the leaf blocks?
Thanks... Received on Fri May 25 2001 - 10:52:14 CDT