Index Management ---------------- Nonclustered Maintenance per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Ins/Upd Requiring Maint 1996.3 25.3 1778674 n/a # of NC Ndx Maint 694.9 8.8 619122 n/a Avg NC Ndx Maint / Op n/a n/a 0.34808 n/a Deletes Requiring Maint 1922.5 24.3 1712946 n/a # of NC Ndx Maint 621.1 7.9 553387 n/a Avg NC Ndx Maint / Op n/a n/a 0.32306 n/a RID Upd from Clust Split 0.0 0.0 0 n/a # of NC Ndx Maint 0.0 0.0 0 n/a Upd/Del DOL Req Maint 9.0 0.1 7989 n/a # of DOL Ndx Maint 9.2 0.1 8238 n/a Avg DOL Ndx Maint / Op n/a n/a 1.03117 n/a Page Splits 11.7 0.1 10452 n/a Retries 0.0 0.0 0 0.0 % Deadlocks 0.0 0.0 0 0.0 % Add Index Level 0.0 0.0 0 0.0 % Page Shrinks 0.1 0.0 124 n/a Deadlocks % Deadlock Retries Exceeded 0.0 0.0 0 0.0 % Index Scans per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Ascending Scans 69751.6 883.1 62148709 29.3 % DOL Ascending Scans 168653.5 2135.3 150270303 70.7 % Descending Scans 8.8 0.1 7884 0.0 % DOL Descending Scans 23.9 0.3 21271 0.0 % ----------- ------------ ---------- Total Scans 238437.9 3018.8 212448167
