TDV provides ways for you to generate and evaluate the execution plans for SQL queries. The execution plan displays characteristics of the overall request, and of each request node, depending on which you highlight. The request hierarchy is displayed on the left (the Tree Panel), and the plan information is displayed on the right (the Details Panel).

When you execute a particular SQL query for the first time, the TDV Server caches the query execution plan so it can reuse it if you resubmit the query later.

Working with the SQL execution plan is described in these sections:

You can also explicitly gather and cache the statistics for a query, such as number of rows in each table. The execution plan helps the TDV Server make better decisions about how to process the query. However, if the statistics change, you should regenerate the query plan so TDV uses up-to-date information. See Creating Cardinality Statistics for Cost-Based Optimization.