I have an 800GB SQL Server Enterprise database with very bad performance. So, based on a few scripts I found online I'm creating a job on my SQL database to maintain our indexes. Most of my tables have a clustered index and 3 or 4 non-clustered.
- Does it make any difference the order in which the indexes are being rebuild/reorganized?
- Is it the same if I first reorganize the clustered index and then the nonclustered ones or if I do it the other way?