olahallengren / sql-server-maintenance-solution

SQL Server Maintenance Solution
https://ola.hallengren.com
MIT License
2.91k stars 756 forks source link

Please see under discussions Help with the Index Optimize solution #449 #477

Open WJBergen opened 3 years ago

WJBergen commented 3 years ago

Need to reorg/rebuild over 28,000 indices on a 40T vendor designed database. IndexOptimize cycles thru tables in ascending table name order. Per the unanswered discussion question, is there another way to cycle thru the indices and on each run to start from where the previous run has left off. This would avoid processing the same table multiple times.