RE: Index key compression - performance benefits?
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: <kmoore@xxxxxxxxxxxx>
- Date: Thu, 31 Aug 2006 22:53:38 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
