Update statistics on the largest tables

administrator

Microsoft SQL Server collects statistical information about indexes and column data stored in the FactoryLogix Database. The statistics are used by the SQL Server Query Optimizer to choose the most efficient way to retrieve or update data.

SQL Server has two options to keep statistics current: AUTO_CREATE_STATISTICS and AUTO_UPDATE_STATISTICS. We recommend you utilize these options weekly or monthly as part of your SQL Server database maintenance plan.

AUTO_CREATE_STATISTICS

• Statistics are created automatically for each new index.

• If the database setting AUTO_CREATE_STATISTICS is ON, the SQL Server will create statistics automatically for non-indexed columns used in your queries.

AUTO_UPDATE_STATISTICS

• Statistics are checked before queries are compiled or before a cached query plan executes. 

• If your queries are executing more slowly than usual, then it is time to use this option to update the statistics. 

• If you analyze performance problems and the root cause is in an index or if certain column statistics aren't current, updating statistics more frequently may solve the problem.

To learn more about SQL Server statistics, consult the Microsoft SQL Server documentation.