Add sorting feature at least at table level, may be indexes also ?

[shub-666]

Hi,

As we are working on big systems and Maintenance windows are never big enough, I think it could be an interesting feature to add sorting capabilities at table level at least (may be also index level.?)

Currently tables and/or Indexes are always processed in the same alphabetical order and that's a problem when maintenance window is not long enough to process a single database.
So i think it could be interesting to have sorting based at least on table name :

• ASC
• DESC
• RANDOM, so the table are processed in random order, you let the system rebuild indexes that will may be never rebuilt in alpha asc order, in automatic plans (because of log files, not big enough depending on table name sort)

WITH ASC & DESC, on manual IndexOptimize (MS SQL compatibility mode upgrade) we can start 2 jobs in // that will process one in ASC order and the other in reverse order, without using @indexes parameters that would be a lot work.

I'm currently in the middle of a big migration operation, and I think i could have help me, avoiding building of complex script (manually settings order in Indexes param : '%.dbo.z%', '%dbo.y%' etc etc

Thank you
Aymeric