INSERT EXPLAIN | SQL Statements | Teradata Vantage - 17.05 - INSERT EXPLAIN - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

Captures the Optimizer white tree information for a query and writes the information to a user-defined query capture database, optionally as an XML document.

For more information about index analysis, see:

ANSI Compliance

INSERT EXPLAIN is a Teradata extension to the ANSI SQL:2011 standard.

Required Privileges

You must have INSERT privileges on the tables in the user-defined query capture database.

You must also have the SELECT privilege on all referenced tables to capture data demographics and column statistics.