on 06-17-2009 10:04 PM
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
>
> 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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
Edited by: Sunny Pahuja on Jun 17, 2009 11:50 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
74 | |
9 | |
7 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.