The data in this section gives information about how delete operations affected indexes on allpages-locked tables:
“Deletes Requiring Maint” reports the number of delete operations that potentially required modification to one or more indexes.
See “Deletes”.
“# of NC Ndx Maint” reports the number of nonclustered indexes that required maintenance as a result of delete operations.
“Avg NC Ndx Maint/Op” reports the average number of nonclustered indexes per delete operation that required maintenance.
