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