Use the Visual EXPLAIN Utility | Teradata Vantage - Procedure Using the Visual EXPLAIN Utility - Advanced SQL Engine - Teradata Database

Database Administration

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

Perform the following procedure to create the tables and other database objects for the query capture database using Visual EXPLAIN.

If you do not have the Visual EXPLAIN tool, then see Procedure Using BTEQ.

  1. Start Visual EXPLAIN.
  2. Pull down the Tools menu and select Control Center.
  3. Select the Manage QCD tab.
  4. Select the Setup QCD button.
  5. Select the Create all QCF database objects (tables and macros) radio button.
  6. Type the name of the database owner in the Owner selection box.
  7. Specify the Perm Space parameter in the Perm Space selection box.
  8. Specify the Spool Space parameter in the Spool Space selection box.
  9. Check the Fallback check box depending on your requirements.
    You cannot use the NO FALLBACK option and the NO FALLBACK default on platforms optimized for fallback.
  10. Select the Create button.
  11. Secure the QCD tables by granting the appropriate privileges to the users who will be analyzing its data.

    You can implement additional secured access by creating views on QCD.

  12. Populate the QCD tables using the appropriate tools.
    • BEGIN QUERY CAPTURE requests to capture request plans.

      For the syntax of this statement, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.

    • INSERT EXPLAIN requests to capture query plans.

      For the syntax of this statement, see Teradata Vantage™ - SQL Data Manipulation Language, B035-1146.

    • COLLECT DEMOGRAPHICS, COLLECT STATISTICS (QCD Form), or INSERT EXPLAIN … WITH STATISTICS, as appropriate.
    • Workload macros to create workloads for index analysis.