jeudi 26 mars 2015

Compressing partition - what about index?


To save space on disk I want to compress some partitions of my tables:



alter table TEST_TAB move partition TEST_TAB_2014 compress for all operations;


I have also indexes on this partition.

Should I recreate indexes after compression, or is it not necessary?





Aucun commentaire:

Enregistrer un commentaire