Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Index key compression

Index key compression

From: Vikas Agnihotri <onlyforposting_at_yahoo.com>
Date: 25 May 2001 08:52:14 -0700
Message-ID: <77e87b58.0105250752.7f026aed@posting.google.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US