How's this for space saving:

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 13 Jul 2005 16:07:17 +0100
Message-ID: <013101c587bc$8f617f20$7b02a8c0@Primary>

Validate index XXX;
select opt_cmpr_count, opt_compr_pctsave from index_stats;

OPT_CMPR_COUNT OPT_COMPR_PCTSAVE
-------------- -----------------

              3                233

So if I compress this index, I can reduce it's space usage by 233% ! (And I've only just created it at pctfree = 10 - so that's not because of current empty space).

Regards

Jonathan Lewis

Now waiting on the publishers: Cost Based Oracle - Volume 1

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/appearances.html Public Appearances - schedule updated 8th July 2005

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jul 13 2005 - 10:10:03 CDT