DB2 Server for VSE & VM: Database Services Utility


Statistics Collection

If SET UPDATE STATISTICS is on, table statistics are automatically generated while the data is reloading. This method of creating statistics avoids a dbspace scan and a separate scan of the index pages, which occurs when an UPDATE STATISTICS statement is issued. If SET UPDATE STATISTICS is off, the statistics are not updated.
Note:Consider using SET UPDATE STATISTICS ON for all RELOAD processing to update the table statistics while the data is reloading.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]