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
Not sure about the extended property thing, though. I think that one is a stretch.
Also, similar issues: #704 and #364
As we can use @TimeLimit, it would be nice to order index optimisation by 1 : needs = index fragmentation 2 : importance = index fragmentation & index size 3 : user choose = given property name in index extended properties
As a result the next run cope optimization in attended fashion