BEGIN QUERY CAPTURE Examples | Teradata Vantage - 17.05 - Example: Using the Default TDQCD Database to Capture and Store a Query Plan in XML Format - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)

This request specifies all of the supported options and uses the default TDQCD database to store the query plan data.

     BEGIN QUERY CAPTURE AS workload wl_2;
     SELECT *
     FROM employee
     WHERE emp_code > 2;

An END QUERY CAPTURE request ends the BEGIN QUERY CAPTURE mode.

     END QUERY CAPTURE;