using Intel Pentium Processor for division again? Raj On 7/13/05, Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx> 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 > > > > > -- > //www.freelists.org/webpage/oracle-l > -- ------------------------------ select standard_disclaimer from company_requirements where category = 'MANDATORY';