SQL & PL/SQL

Hello folks,

I have a situation where I want to delete quite sizable rows from a set of tables where there are around 4 million rows present at any time. I cannot use partitioning concepts for most of my customers are not on oracle EE. With this background, I analyzed all indexes I have on various tables to figure out that most of the indexes are good candidates of compression where OPT_CMPR_COUNT is 1 through 4 for some indexes giving likely saving in storage (OPT_COMR_PCTSAVE) between 59 and 48 %.

I was wondering to what extent my deletes will get boost if I think of compressing these indexes.

Thanks in advance for any valuable comment, suggestions.

Thanks,
Girish

Edited by: girishkale on Dec 31, 2012 1:24 PM