SQL Server uses statistics for a lot of things, but one of the most valuable is determining whether it should seek or scan a particular index or scan. The stats aren’t always useful, though, especially if your T-SQL isn’t sargable.

Leave a Reply

Your email address will not be published.

Fill out this field
Fill out this field
Please enter a valid email address.