Re: Help to optimize subpartition
Posted by:
Rick James
Date: April 20, 2012 06:54PM
OPTIMIZEing a partition leads to OPTIMIZEing the entire table. (This is a known bug; I found it the hard way.) The workaround is to REORGANIZE the one partition that you want to OPTIMIZE.
What benefit do you hope to get from this partitioning? Will you be dropping "old" partitions? The HASHed subpartitions seem to be useless.
Do you do lots of DELETEs? Otherwise, why do you need OPTIMIZE?
Subject
Views
Written By
Posted
3429
April 19, 2012 05:28AM
Re: Help to optimize subpartition
2182
April 20, 2012 06:54PM
2040
April 21, 2012 04:15PM
1972
May 02, 2012 07:59AM
1555
May 02, 2012 01:41PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.