Skip to Content
Former Member
Apr 01, 2011 at 12:52 PM

regular indexes rebuild at SQL-Server 2008 and higher necessary?


Dear SAP-Community

Iu2019m wondering if itu2019s necessary to do a regular indexes rebuild on SQL-Server databases. My problem is that I haven't found anything in the ADM520 nor an official documentation nor a SAP note which would advice me.

Is there any SAP recommendation to do it regularly?

If yes how does the command look like?

Is there a report or command to check if there are defragmented indexes?

Does someone of you have an official link to SAP documents regarding this topic?

Thanks in advance!

Cheers, Manuel