Tag Archives: creates

SQL Server creates a histogram on the leading key but not on the other columns

the leading key should be the most selective column—number in our case. Allegedly (according to the recommendation), SQL Server creates a histogram on the leading key but not on the other columns; so if you follow the recommendation, the optimizer … Continue reading

Posted in SQL Server | Tagged , , , , , | Comments Off on SQL Server creates a histogram on the leading key but not on the other columns