This section describes the purpose of each check box and explains how to use each option. Check boxes also can be used in combination.
Select check boxes under Export Options, located in the export dialog boxes (Export By Query, Export By Database, and Export By Workload), to define the information exported from a target system. Availability of the check boxes varies according to the type of export selected.
When exporting by query and either typing a query manually or loading a query from a file, the execution plans are captured and exported depending on the options selected for Execution Plans, Export Plans in XML (Customization option), Export Dynamic Plans(Customization option), and Demographics as described below.
Export Dynamic Plans | Export Plans in XML | Execution Plans | Demographics | Description |
---|---|---|---|---|
Unchecked | Checked | Checked | Unchecked | INSERT EXPLAIN in XML captures the plan into a QCD database and deletes it after the export operation. |
Unchecked | Unchecked | Checked | Unchecked | DUMP EXPLAIN captures the plan. |
Unchecked | Checked or Unchecked | Checked | Checked | INSERT EXPLAIN captures the plan into a QCD database and deletes it after the export operation. |
Checked | Unchecked | Checked | Irrelevant | IPE Plan is captured in SystemFE.Opt_XMLPlan_Table. |
During an import operation, the QCD plans are imported into the database listed in the QCD Name box. The DBQL Plans are imported into the external DBQL Database. Dynamic Plans are imported into SystemFE.Opt_XMLPlan_Table.
If the Execution Plans check box is selected and the Export table data used by query optimization check box is selected when customizing options (see Customization Options for more information), table data used by query optimization is captured.
For more information, refer to SQL Request and Transaction Processing (B035-1142).
- Cost parameters
- Cost profiles
- Demographics
- RAS
After defining the options, Teradata SET can be used to estimate how long the export will take given the options selected. See Viewing the Estimated Export Time.
For a description of each option, see the following sections.