Re: Compressing partitions

Hi Michael and Tanel,  

> If you want to do physical row ordering, then that's one way to go:

> create table temp nologging compress as select * from your_table partition p1 order > by col1,col2,col3;

you may also consider alternative physical ordering (i.e. some trade-off between access speed and high compression). A good candidates for leading columns in order by are columns with high average column length and with low number of distinct values. Even the partitioning schema (daily, weekly etc.) can influence the compression factor. Remember that only repeated values within one block are compressed.  

If you plan to change the structure of the table (add column) you should check the availability of this feature in your version. (There are some limitation in the versions below 10).  

Regards  

Jaromir

• Original Message ----- From: Tanel Põder To: ORACLE-L Sent: Monday, July 04, 2005 2:37 PM Subject: Re: Compressing partitions

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