Creating and Updating Statistics

  • Article

In SMO, statistical information about processing queries in the database can be collected by using the Statistic object.

It is possible to create statistics for any column by using the Statistic and StatisticColumn object. The Update method can be run to update the statistics in the Statistic object. The results can be viewed in the Query Optimizer.