EitanBlumin
commented
1 year ago +1 on this. Same need here. It would be great having various sorting options available for tables or indexes:
- Name asc/desc
- Size (page count) asc/desc
- Statistics modification counter (modctr) asc/desc
- Last stats_date asc/desc
- Fragmentation percent asc/desc
- Order as specified in the
@Indexesparameter
Also, similar issues: #460 and #364
For IndexOptimize, the databaseorder parameter is nice to have, when you have multiple databases. But with one large database, it would also be nice to have a TableOrder parameter, to sort through tables ascending or descending. Sometimes our job runs out of time, so next time, I would like it to start in descending order, so at least we have a chance of rebuilding all tables at least 50% of the time.