Displaying a Visual EXPLAIN Plan - SQL Assistant

Displaying a Visual EXPLAIN Plan

You can display a visual EXPLAIN of a single-statement query currently in the Query Window.

This menu command appears if:

You have the Teradata Visual Explain application (version 3.0 or later) installed on your PC, and

If you are connected to a Teradata Database

1 Select Tools > Visual Explain.

2 In the Visual Explain dialog box, enter the name of the Query Capture Database (QCD) and click OK.

Note: It takes a few moments for the Insert Explain statement to execute, and you cannot continue using SQL Assistant until Visual Explain is launched.

To set up a QCD, refer to the Teradata Visual Explain User Guide.