Tag Archives: histogram

How SQL Server Optimizer Calculates the Estimated Row Count

How SQL Server Optimizer Calculates the Estimated Row Count This post can help you out in understanding “How SQL Server Optimizer Calculates the Estimated Row Count”. Once query is submitted, query optimizer takes the help from Histogram (Cardinality Estimates) statistics … Continue reading

Posted in Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , | 1 Comment