Browse by Tags

• Database Engine Tuning Advisor
• Execution Plans
• Hypothetical Indexes
• Performance
• Query Optimizer

• The Query Optimizer and Cost Estimation

  Last year when I presented my session regarding the Query Optimizer at the PASS Summit and at a couple of local user groups, I was asked how the estimated CPU and I/O costs in an execution plan are calculated. Since Microsoft does not publish how these Read More... Posted Wednesday, February 17, 2010 9:23 PM by Ben Nevarez | 1 Comments Filed under: Query Optimizer, Cost Estimation, Execution Plans

• Database Engine Tuning Advisor and the Query Optimizer

  Did you know that the Database Engine Tuning Advisor (DTA) uses the Query Optimizer to help you to create indexes, indexed views, and partitions for your databases? The DTA uses the Query Optimizer to estimate the cost of queries so it can select the Read More... Posted Wednesday, November 11, 2009 8:47 PM by Ben Nevarez | 4 Comments Filed under: Query Optimizer, Performance, Cost Estimation, Database Engine Tuning Advisor, Hypothetical Indexes