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

Other related posts: