Skip to content
English
More support Sign in
Contact us
  • There are no suggestions because the search field is empty.

Database Index Rebuild/Repair

Search

Database Index Rebuild/Repair

This should work for tracks that on SQL Server 2008 and up.    WARNING: THIS SHOULD ONLY BE EXECUTED WHEN A TRACK IS CLOSED. (Exclude the 1st, 2nd, 3rd labels)  
  1. Run the attached "1st - indexFragmentation.sql" script to determine if the track needs to be re-indexed.
  2. If you see some indexes above 90%, proceed. If not, let Level 2 know and look for other things that could be causing performance issues.
  3. Run the attached "2nd - ReindexUpdateStatistics.sql" This will drop, recreate, adjusts primary, etc. This will speed up queries.

 

If you know the exact index that needs adjustments (check with level 2 or devs first), then proceed:

 1st   USE ClubspeedV8 EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?')"      2nd      3rd   sql (16.5 KB) sql (539 Bytes)

Related Articles