Optimizing SQL Server Query Performance

  • Article

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

  1. For each Commerce Server 2002 table that can potentially contain a large volume of data, run the following script:

    UPDATE STATISTICS <Tablename> with FullScan

  2. Run this script for the CatalogGlobal table.

  3. For each base catalog, run this script for the following tables:

    • CatalogName_CatalogProducts
    • CatalogName_CatalogHierarchy
    • CatalogName_CatalogRelationships

  4. 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.