Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.