Re: Index key compression

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Fri, 25 May 2001 16:01:54 GMT
Message-ID: <3b0e8058.24257419@news-server>

On 25 May 2001 08:52:14 -0700, onlyforposting_at_yahoo.com (Vikas Agnihotri) wrote:

>
>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?
>

Vikas, you need to get Jonathan's book. It has an excellent section daling precisely with this.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Fri May 25 2001 - 11:01:54 CDT