Running update statistics
The update statistics command updates column-related statistics, such as histograms and densities.
Updating Statistics on Specific Columns
Creating statistics on unindexed columns can improve the performance of many queries. Adding statistics for the minor columns of indexes and for unindexed columns that are frequently used in search arguments can greatly improve the optimizer’s estimates.