Re: Compressing partitions
- From: "jaromir nemec" <jaromir@xxxxxxxxxxxx>
- To: <tanel.poder.003@xxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>, <Michael.Kline@xxxxxxxxxxxx>
- Date: Mon, 4 Jul 2005 22:53:44 +0200
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:
