THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Query Optimizer » Hypothetical In... » Performance   (RSS)
  • 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 choices with the lowest estimated cost. But, how can the Query Optimizer estimate the cost of a ...
    Posted to Benjamin Nevarez (Weblog) by Ben Nevarez on November 11, 2009
Privacy Statement