The following table describes the Teradata Visual Explain command line switches.
| Switch | Description |
|---|---|
| ux | Use DBC and QCD X views (on Teradata Database V2R6.0, V2R6.1, and V2R6.2) or DBC and QCD VX views (on Teradata Database 12.0 and later) while retrieving plans from a QCD. The Use X views (DBC and QCD) check box must be selected.
|
| unx | Use DBC and QCD non-X views (on Teradata Database V2R6.0, V2R6.1, and V2R6.2) or DBC and QCD V views (on Teradata Database 12.0 and later) while retrieving plans from a QCD. The Use X views (QCD only) check box must be cleared.
|
| uxq | Use only QCD X views (on Teradata Database V2R6.0, V2R6.1, and V2R6.2) or only QCD VX views (on Teradata Database 12.0 and later) while retrieving plans from the QCD. The Use X views (QCD only) check box must be selected.
|
| v | Specify expanded or compressed view mode for plan display. The default view mode is expanded. |
| p | Specify Open Online plans operation. |
| ie | Specify Insert and View Execution Plan operation. |
| vc | Specify Visual Compare of Execution Plans operation. |
| tc | Specify Textual Compare of Execution Plans operation. |
| ec | Specify Explain text differences of Execution Plans operation. |
| rc | Specify a range of queryID. |
| bc | Specify Bulk Compare of Execution Plans operation. |
| f | Specify a file name. |
| l | Specify CLIv2 connectivity. |
| c | Specify ODBC connectivity. |
| am | Connect to the server using a specific alternate logging mechanism. |
| d | Specify the QCD database name. |
| m | Specify output in multiple files. It is used in bulk compare. |
| t | Specify Query Tag. It is used in Insert and View Execution Plan operation to specify query tag while inserting the execution plan. |
| q | Specify query text. It is used in case of Insert and View Execution Plan. |
| db | Specify the default database name in case of command line INSERT EXPLAIN. The database supplied is only effective in case of INSERT EXPLAIN command line. |
| a | Used with textual compare to display all types of differences. |
| cs | Used with textual compare to display cost differences only. |
| ic | Used with textual compare to display index condition differences only. |
| jc | Used with textual compare to display join condition differences only. |
| rsc | Used with textual compare to display residual condition differences only. |
| jo | Used with textual compare to display join order differences only. |
| op | Used with textual compare to display operation differences only. |
| opd | Used with textual compare to display operand differences only. |
| sc | Used with textual compare to display Teradata Database configuration differences only. |
| scs | To connect to the server using a specified session character set. |
| ta | Used with textual compare to display target attribute differences only. |
| iex | Specify Insert Explain in XML and View Execution Plan captured in XML format in QCD. Only available for Teradata Database version 13.10 and later.
|
| xml | View execution plan captured in xml format in QCD. Only available for Teradata Database version 13.10 and later.
|
| eix | View execution plan generated from database using Explain In XML command. |