Analyzing queries using Database Engine Tuning Advisor
There are few different ways that can help you in providing workload to DTA. One of the popular ways is to ask DTA about the query you are designing at the moment for performance point of view, so that DTA can analyze the query and provide suggestions, if any.
We will need two tables to demonstrate this recipe. Here is the script to create the same:
USE AdventureWorks2012 GO IF OBJECT_ID('ProductDemo') IS NOT NULL DROP TABLE ProductDemo GO IF OBJECT_ID('ProductModelDemo') IS NOT NULL DROP TABLE ProductModelDemo GO select * into ProductModelDemo from Production.ProductModel select * into ProductDemo from Production.Product GO
We have just created two tables, named
ProductDemo and ...