How's this for space saving:
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 13 Jul 2005 16:07:17 +0100
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
Other related posts:
