RE: Index key compression - performance benefits?

Keith

> I ran the command in a test system and all the stats were generated
> except compression. Any idea why? It is Oracle 9.2.0.4, 64 bit on
> Solaris.

<snip>
> I then dropped and recreated the index with 'compress 1' and got
> about 50% compression.

I see only two possibilities...

1. They calculation is buggy.
2. In your index there was a lot of free space. To confirm/deny this point you could simply try to create a fresh index with and without compression...

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l