Explaining SQL Server Statistics

Query optimizer depends on statistics to estimate the cardinality or number of rows of a query result. In other words, it is the knowledge of how many rows are in a table, and how many of those rows satisfy the various search and join conditions, and so on. Based on this, optimizer creates the best query plan. Sometimes, tweaking the statistics helps to produce efficient query plan. In this article, we are going to explore the fundamentals of SQL Server statistics. [More]