Need to Check Large objects and Index Quality/Reorg

[Former Member]

Hello,

I need to reorganize some large objects, how can we check what all are the large objects in database? so we can do reorganization of large objects.

Second thing is that some of index's are too big that also need to be reorganization, so i have to carry out index reorg also.

I have some doubts,

1) what is index quality and how can we check the existing index quality? what should be good index quality?

2) What is index rebuild/Index rebuild online and index compression, which one is the better for index reorganization?

Response will be highly appricitable.

Regards,

V.Singh

[Former Member]

Hi

Kindly check the below links.

1. http://help.sap.com/saphelp_nwmobile71/helpdata/en/49/2a7beb2ffc2583e10000000a421937/content.htm

2.http://help.sap.com/saphelp_45b/helpdata/en/0d/d2fb314a0c11d182b80000e829fbfe/frameset.htm

Hopes it helps you.

Regards

Sirigiri

[Former Member]

Hi,

1) what is index quality and how can we check the existing index quality? what should be good index quality?

1.From DB02--> detail analysis menu you can take out top 50 tables & indexes. you can mark the size of the index should be generally less than the table.If its more or very much similar size of table, you can rebuild it using SE14. This can free some space.

or else you may use brspace to do this.

http://help.sap.com/saphelp_nw70/helpdata/EN/58/6bec38c9fa7e44b7f2163905863575/frameset.htm

2. Earlywatch alert gives the top 20 degenerated index. you can check that which also gives a factor 'storage quality'.

2) What is index rebuild/Index rebuild online and index compression, which one is the better for index reorganization?

You can use report RSANAORA to rebuild index from SAP level.

Also check below notes

Note 912620 - FAQ: Oracle indexes

Note 332677 - Rebuilding fragmented indexes

Note 682926 - Composite SAP note: Problems with "create/rebuild index"

Note 691764 - RSANAORA enhancement: online option for index rebuild

Check

Hope it helps.

Thanks,

Sushil

[markus_doehr2]

> I need to reorganize some large objects,

So what is a "large object" in your definition? Since you apparently "need" to reorganize you must know, what you need to reorganize...

> how can we check what all are the large objects in database? so we can do reorganization of large objects.

see above

> 1) what is index quality and how can we check the existing index quality? what should be good index quality?

> 2) What is index rebuild/Index rebuild online and index compression, which one is the better for index reorganization?

Note 771929 - FAQ: Index fragmentation

Note 1109743 - Use of Index Key Compression for Oracle Databases

Note 766349 - FAQ: Oracle SQL optimization

Markus