Bookshelf Home | Contents | Index | Search | PDF

Siebel Server Installation Guide for Microsoft Windows > Creating the Microsoft SQL Server Database > Ongoing Microsoft SQL Server Database Administration >

Updating Statistics

---

The cost-based optimizer in Microsoft SQL Server uses statistics about tables and indexes to compute the most efficient access plans. When statistics become inaccurate, as can happen for tables with high insertion or deletion rates and for their associated indexes, the performance of database operations can degrade dramatically.

You should always perform a full scan of all your tables under the following circumstances, even if you implement automatic statistics updating:

After your Siebel Database installation and before starting Siebel eBusiness Applications.
After you run concurrent EIM threads.
After you insert, update, or delete large amounts of data.

Using Query Analyzer, perform a full scan of each table by entering the following command:

update statistics Table Name with full scan

It is strongly recommended that you enable the automatic creation and updating of statistics, using the parameters documented in MS SQL Server Configuration Guidelines. This way, statistics are automatically kept up to date and the administrative overhead of updating them manually is removed.

If you do not implement automatic statistics updating, then periodically perform the full scan described in this section.

Bookshelf Home | Contents | Index | Search | PDF