Run or Explain a Query - Teradata Administrator

Teradata Administrator User Guide

Product
Teradata Administrator
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2502
lifecycle
previous
Product Category
Teradata Tools and Utilities

Run or Explain a Query

Use the following procedures to run or explain a query.

To run a query

1 From the main window, click Tools>Query.

The Query window appears. For more information, see “Query Window” on page 120.

2 Do one of the following:

  • To enter a new query, type it into the note pad area.
  • To load a previously saved query:
  • i From the Query window, click File>Open.

    i From the Query window, click File>Open.

    ii From the Open dialog box, select the SQL file (*.sql).

    iii Click Open to load the file into the note pad area.

    3 Click Tools>Run Query.

    The output appears in the Query Results window. For more information, see “Results Window” on page 126.

    To explain a query

    1 From the main window, click Tools>Query.

    The Query window appears.

    2 Do one of the following:

  • To enter a new query, type it into the note pad area
  • To load a previously saved query:
  • i From the Query window, click File>Open.

    i From the Query window, click File>Open.

    ii From the Open dialog box, select the SQL file (*.sql).

    iii Click Open to load the file into the note pad area.

    3 Click Tools>Explain Query.

    The Explain appears in the Output from Explain window.