Update Statistics for SQL Server - Intergraph Smart Electrical - 10 - Installation & Upgrade - Hexagon PPM

Intergraph Smart Electrical Installation and Upgrade

Language
English (United States)
Product
Intergraph Smart Electrical
Search by Category
Installation & Upgrade
SmartPlant Foundation / SDx Version
Smart Electrical Version
10
Smart Instrumentation Version
(none)
Smart P&ID Version
10
Smart Engineering Manager Version
11
  1. Click Start > Programs > Microsoft SQL Server > SQL Server Management Studio.

  2. Connect to the server.

  3. In the Microsoft SQL Server Management Studio window, under the Object Explorer, select the server (top-level node), right-click, and on the shortcut menu, click New Query.

  4. Type the following SQL script with the name of your database, for example:

    USE Site_Server1_DB
    GO
    EXEC SP_UPDATESTATS

This script updates the statistics for every table in the database.