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:
- BEGIN QUERY LOGGING and REPLACE QUERY LOGGING in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
- COLLECT DEMOGRAPHICS
- COLLECT STATISTICS (QCD Form)
- DUMP EXPLAIN
- INSERT EXPLAIN
- INITIATE INDEX ANALYSIS
- RESTART INDEX ANALYSIS
- Teradata Vantage™ - SQL Request and Transaction Processing, B035-1142
- Teradata Vantage™ - Database Design, B035-1094
- Teradata® Viewpoint User Guide, B035-2206, Stats Manager topic
- Teradata® System Emulation Tool User Guide, B035-2492
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.