16.10 - Procedure Using the Visual EXPLAIN Utility - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

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.
  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 SQL Data Definition Language Syntax and Examples.

    • INSERT EXPLAIN requests to capture query plans.

      For the syntax of this statement, see SQL Data Manipulation Language.

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