Index Storage Quality

[Former Member]

Hi All,

We are in phase of setting automatic intimation for any index whose storage quality is below to 50%.

So our plan is that we should get any alert for indexes whose storage quality is below to 50% quaterly. For it we have identified one report RSORAISQN which shows will work for us in such way that we will scedule it and by spool files email we will get out indexes.

But issue is we are not understanding with what options we should execute the report as for all selection cretaria we do not get any output.

We also checked note 970538 - Collective note RSORAISQN and assigned

grant UNLIMITED TABLESPACE to <dbuser>;

grant CREATE TABLE to <dbuser>;

grant ALTER TABLESPACE to <dbuser>;

grant SELECT ON DBA_INDEXES to <dbuser>;

grant SELECT ON DBA_TABLES to <dbuser>;

grant SELECT ON DBA_SEGMENTS to <dbuser>;

permissions but still same situation on output.

Please let us know is there any other way available to check storage quality of all indexes and if report RSORAISQN is only option then how can we execute it.

Shivam Mittal

[Former Member]

Hi Shivam,

You can find the 3 different method to see index storage quality in the SAP Note 771929 - FAQ: Index fragmentation

Additionally, check the note 712098 - RSORAISQ: Index Storage Quality Management, in order to fix authorization problem.

In order to generate the list, you should analyze it first. Then you will be able to see the result.

Best regards,

Orkun Gedik

Edited by: Orkun Gedik on Jun 29, 2011 6:42 PM

[Former Member]

Hello Shivam,

first of all, why do you care about the Index Storage Quality?

If you want to reclaim wasted space, an index rebuild might make sense. (But fragmentation will come back, no doubt about that.)

If you want to improve the performance, then an index rebuild will very rarely make sense.

Read this presentation, it is very good and demystifies the Index Storage Quality:

http://richardfoote.files.wordpress.com/2007/12/index-internals-rebuilding-the-truth.pdf

Summary: Don't worry about Index Storage Qualtiy, be happy!

Regards,

Mark