The ascinserts property of a table allows customers to insert records into a table in sorted order. If tables occasionally experience random inserts and have more ordered inserts during batch jobs, enable ascinserts only for the period the batch runs.
Enable the ascinserts option using:
sp_chgattribute “objname”, ascinserts, 0 |1
For example, to enable ascinserts for the titles table:
sp_chgattribute “titles”, ascinserts, 1
sp_help includes the value of ascinserts for any all-pages-locked table in its output.
This value is stored by bit 6 of the status2 column in sysindexes, and a value of 64 for this column indicates that ascinserts is enabled for this table.
ascinserts has also been added to dbcctune().
