Re: How's this for space saving:

using Intel Pentium Processor for division again?  Raj

 On 7/13/05, Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:
>
>
> 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
>

-- 
------------------------------
select standard_disclaimer from company_requirements where category = 
'MANDATORY';

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