Note: Before you proceed with the following instructions, back up the database. If your organization integrates multiple Blackbaud products, refer to the Additional Requirements section of the backup solution.Microsoft® SQL Server keeps statistical information regarding the distribution of values (e.g. key values) in a column to be created (e.g. index). The query optimizer uses this statistical information to determine which indexes to use in query processing in order for the query to process as quickly as possible.
Note: For more information on indexes and relational databases, refer to an Introduction to Relational Databases.
When a lot of changes are made in the database, the statistics can become out-of-date causing the query optimizer to make less than optimal decisions on which index to use when running a query. This leads to the degradation of performance when running queries. By updating the statistics, the query optimizer is able to make decisions based on up-to-date statistics causing the queries to process more quickly.
If you have purchased your own version of SQL Server, you can use the Blackbaud Management Console or write a SQL statement to update the statistics.
If you use SQL Server Express 2005 or SQL Server 2008 R2 Express included with some Blackbaud products, then use the Blackbaud Management Console (BMC) to update statistics. We recommend running Update Statistics whenever query performance starts to degrade or whenever you perform a large global function to update the database such as importing/updating, globally deleting, or globally changing a large number of records.
To run Update Statistics:
- Open the Blackbaud Management Console and highlight the Maintenance option for the affected database
- Click Update Statistics
- Click Update
Note: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites, and we cannot assist in implementing the solutions on these websites.