Viewing the Execution Plan from the DBQL

Teradata Visual Explain User Guide

brand
Teradata Tools and Utilities
prodname
Visual Explain
vrm_release
16.10
16.20
category
User Guide
featnum
B035-2504-086K

View the Explain results graphically or textually after the XML execution plan has been logged into the DBQL.

DBQL XML plans larger than 31K cannot be viewed using this procedure when connected to Teradata Database 13.00. This limitation is removed for Teradata Database 13.10 and higher.
  1. Click .

    The Select Execution Plan(s) to Open (DBQL) window appears.

    Select Execution Plan(s) to Open (DBQL)

  2. In the tree view, right-click the DBQL XML plans node and select Browse DBQL Plans.


    The Select DBQL Criteria dialog box opens.

    Select DBQL Criteria

  3. Enter the criteria in the dialog box.
    Option Description
    Log Option Select one of the following:
     
    • DBQL (default) and browse XML queries from the DBQL or,
    • External Database and browse XML queries from an external database.
    Date Range
    Start Date Start date, in the format MM/DD/YYYY, to use when searching for queries on or after the date. If no start date is specified, all statements from the DBQL are loaded.
    End Date End date, in the format MM/DD/YYYY, to use when searching for queries on or before the date. If a start date is specified but no end date is specified, all statements from the DBQL beginning at the start date are loaded.
    Start Time Start time in the format HH:MM:SS to use in searching for queries on or after the start time. If no start time is specified, the default start time is 00:00:00.
    End Time End time in the format HH:MM:SS to use in searching for queries on or before the end time. If no start time is specified, the default end time is 13:59:59.
    DBQL Filter Options [Optional]
    Est Proc Time Minimum estimated processing time for the queries received from the DBQL.
    CPU Time Minimum processing time for the queries received from the DBQL.
    Step Count Minimum number of steps for the queries received from the DBQL.
    Rows Minimum number of rows returned for the queries retrieved from the DBQL.
    Select Users and Accounts Opens the Select Users and Accounts dialog box.

    Browse a list of users and accounts, and select one or more users or one or more accounts to include in the search. Selected user or account names are displayed on the right-hand side of the dialog box.



    Select Query Band
    List Names List all the Query Band Names in the Name-Value list.
    Name Name of a Query Band Name-Value pair.

    See “SET QUERY_BAND” in SQL Data Definition Language (B035-1144) for more information.

    Value Value of a Query Band Name-Value pair.
    Add Add the selected Query Band Name-Value pair to the Name-Value list.
    Rem Remove the selected Query Band Name-Value pair from the Name-Value list.
    Name-Value Combination of the Name and Value entries (Name-Value pair).
    Filter Use to filter out some of the Query Band Name-Value pairs.
  4. Click OK to close the Select DBQL Criteria window.
  5. In the Select Execution Plan(s) to Open (DBQL Plans) window, right-click the QueryID and select the Add checkbox in the Available Execution Plans list.
    Right-click a specific DBQL and select Add All to add all available plans to the Selected Execution Plans list.
  6. [Optional] To see a complete statement text, right-click Statement Text, select a statement, and click.

    For more information on the Statement Text dialog box, see Viewing Statement Text.

  7. Click Open to display the plans.
  8. Click OK to close the Select Criteria dialog box.