Optimizing SQL Server Query Performance
Incorrect or outdated statistics can make a significant difference in the amount of time it takes to run a query on a table containing large volumes of data.
To update the index statistics for Commerce Server 2002 tables
For each Commerce Server 2002 table that can potentially contain a large volume of data, run the following script:
UPDATE STATISTICS <Tablename> with FullScan
Run this script for the CatalogGlobal table.
For each base catalog, run this script for the following tables:
- CatalogName_CatalogProducts
- CatalogName_CatalogHierarchy
- CatalogName_CatalogRelationships
For each virtual catalog, run this script for the following tables:
- CatalogName_CatalogProducts
- CatalogName_CatalogHierarchy
- CatalogName_CatalogRelationships
- CatalogName_CATALOGVIRTUALPRODUCTS
Copyright © 2005 Microsoft Corporation.
All rights reserved.