SQL server update statistics

Perform the update statistics procedure to ensure that selectivity factors are updated when there are significant changes to an index.

You might want to perform this procedure daily, especially if large amounts of data are inserted, updated, or deleted. You can run update statistics from the actions menu in the Database Configuration application, or use a database-specific command.



Feedback