The following comment for the truncate table command in its reference pages is incorrect:
“truncate table deallocates the distribution pages for all indexes; remember to run update statistics after adding new rows to the table.”
Replace the comment with the following:
truncate table
Adaptive Server no longer uses distribution pages; statistical information is now stored in the tables sysstatistics and systabstats.
During truncate table, statistical information is no longer deleted (deallocated), so it is unnecessary to run update statistics after adding data.
truncate table does not delete statistical information for the table.
