For reindex operations need:
1) add maxdop options
2) add support for WAIT_AT_LOW_PRIORITY parameters (MAX_DURATION and ABORT_AFTER_WAIT)
3) work in multi-threaded mode (each table in a separate thread to avoid locks)
4) multithreaded operations must be logged (started, done, failed).
5) reorganize should be replaced with rebuild if page lock level for index was disabled.
dobrozol
commented
2 years ago
For reindex operations need: 1) add maxdop options 2) add support for WAIT_AT_LOW_PRIORITY parameters (MAX_DURATION and ABORT_AFTER_WAIT) 3) work in multi-threaded mode (each table in a separate thread to avoid locks) 4) multithreaded operations must be logged (started, done, failed). 5) reorganize should be replaced with rebuild if page lock level for index was disabled.