DUMP EXPLAIN Examples | SQL Statements | Teradata Vantage - DUMP EXPLAIN Examples - Advanced SQL Engine - Teradata Database

SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
qtb1554762060450.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata Vantage™

Examples

The following example set uses the same SELECT request throughout to illustrate how the different syntax options of DUMP EXPLAIN produce different results.

Each DUMP EXPLAIN request generates a set of INSERT requests for the query plan produced by the Optimizer for the SELECT request that it modifies.

Example: DUMP EXPLAIN Request With Null Query Plan Name

The output of this DUMP EXPLAIN request has a null query plan name in the TLE_queries database. Compare this to Example: DUMP EXPLAIN Request With Query Plan Name below, which assigns a name to the dumped query plan.

DUMP EXPLAIN INTO TLE_queries
     SELECT emp_id, emp_address
     FROM employee
     WHERE emp_name = 'Smith';

Example: DUMP EXPLAIN Request With Query Plan Name

The output of this DUMP EXPLAIN request is referenced under the query plan name Employee Smith Query in the TLE_queries database.

DUMP EXPLAIN INTO TLE_queries AS "Employee Smith Query"
     SELECT emp_id, emp_address
     FROM employee
     WHERE emp_name = 'Smith';