List of Indexed have Storage Quality less than 80% !!

[former_member69568]

Hi.. Experts

We are planning to keep our all SAP System Indexes to storage quality of 80% +.

Requirement

How can i find out list of indexes having Storage Quality less than 80% directly in the system.

we have reviewed "Note 771929 - FAQ: Index fragmentation" - but we think we did not get answer to our question thru the note.

Rgds

[fidel_vales · Accepted solution]

>

> Hi.. Experts
> ...
> we have reviewed "Note 771929 - FAQ: Index fragmentation" - but we think we did not get answer to our question thru the note.

O_o

Have you really really really readed the note? The following point is giving you the answer to your question:

> 9. How can I detect fragmented indexes?

I do not think so as it gives you several options to calculate the "storage quality", some better, some worse, some faster, some slower, therefore you have to decide hte one that fits your needs.

[debasissahoo]

Jyoti,

you can look at the Early watch report you get the top 20 index which has the least storage quality.

or follow SAP Note 712098 to run report RSORAISQ which does Index Storage Quality Management. (for running this report you may need to assign the SAP user some priviledge as mentioned in the note)

Thanks,

Debasis.

[sunny_pahuja2]

hi

Edited by: Sunny Pahuja on Jun 17, 2009 11:50 PM