Quantifying compile time
The previous post in this series introduced the idea of query execution plans. These plans are compiled by the SQL Server optimizer when a query is executed in an effort to decide an efficient manner in which to execute a query. This compilation takes time and effort beyond that of actually running the query. While most compilation effort is relatively small, at times it can be significant and be an impetus to query performance. In this post we’ll offer methods to measure that time and effort. The demos below utilize the WideWorldImporters DB that can be downloaded for free. To follow along open SSMS, create a new queryRead More →