Works "analyze index validate structure" not for partition index to get the best compress factor?
Hello,
Oracle 11.2.0.3 PU5
I want to compress an index with a lot of partitions with the best compression factor. And the onliest method I know is the old analyze command: analyze index validate structure - is this right or exists another method to get the best compress factor?
After I analyzed the index I read index_stats, but there I see only one row with one partition of the index and this partition has no rows. What's that? Where are the information of the other partitions? Can't I use the analyze command with partition indexes?
Thank you for any help!!
Oracle 11.2.0.3 PU5
I want to compress an index with a lot of partitions with the best compression factor. And the onliest method I know is the old analyze command: analyze index validate structure - is this right or exists another method to get the best compress factor?
After I analyzed the index I read index_stats, but there I see only one row with one partition of the index and this partition has no rows. What's that? Where are the information of the other partitions? Can't I use the analyze command with partition indexes?
Thank you for any help!!
0