The Optimization Process - Inside the SQL Server Query Optimizer - page 142

- - optimize these queries now
- - so they do not skew the collected results
GO
SELECT *
INTO after_query_optimizer_info
FROM sys . dm_exec_query_optimizer_info
GO
SELECT *
INTO before_query_optimizer_info
FROM sys . dm_exec_query_optimizer_info
GO
DROP TABLE before_query_optimizer_info
DROP TABLE after_query_optimizer_info
GO
- - real execution starts
GO
SELECT *
INTO before_query_optimizer_info
FROM sys . dm_exec_query_optimizer_info
GO
- - insert your query here
SELECT *
FROM Person . Address
- - keep this to force a new optimization
OPTION ( RECOMPILE )
GO
SELECT *
INTO after_query_optimizer_info
FROM sys . dm_exec_query_optimizer_info
GO
SELECT a . counter ,
( a . occurrence - b . occurrence ) AS occurrence ,
( a . occurrence * a . value - b . occurrence *
b . value ) AS value
FROM before_query_optimizer_info b
JOIN after_query_optimizer_info a
ON b . counter = a . counter
WHERE b . occurrence <> a . occurrence
DROP TABLE before_query_optimizer_info
DROP TABLE after_query_optimizer_info
Listing 5-3.