MS SQL 2005 Rebuild / Reorg Indexes / ECC6.0

[Former Member]

Hello All,

I have MS SQL 2005/Windows 2008 / ECC6.0 , I would like to rebuild / reorg the indexes in deatbase. I have gone thru some of the OSS notes but did not find the script how to find the indexes needs be rebuild/reorg and what is the SAP recommandation.

any one has done this before please let me know the process.

Thanks

AI.

[markus_doehr2]

Check

Note 159316 - Reorganizing tables on SQL Server

and the link at the bottom of the note to find out if a reorganization of indexes is really necessary.

In my experience you get more performance if you upgrade to SQL Server 2008 R2 (10.50), install the latest service pack (SP1) plus the latest cumulative update (CU1) and then enable table and index compression where the tables and indexes will be rebuilt. This will save space (depending on your data up to 50 %).

Note 1488135 - Database compression for SQL Server

Markus

[former_member184473]

Hello Al,

With SQL Server databases, SAP doesn't recommend to update statistics / reorganize / rebuild objects. Statistics update is done by SQL Server itself on a regular basis and reorganization does not bring any advantage (only in very very few expectional cases).

Also, note [159316|http://service.sap.com/sap/support/notes/159316] shows:

The following article helps you understand if and when a data reorganization (defragmentation) is useful. You MUST read the following article very carefully.
http://technet.microsoft.com/en-us/library/cc966523.aspx
SAP generally advises against performing regular and time-consuming reorganizations of your SQL Server database.

Regards,

Eduardo Rezende