-
From the main window, select .
The Options dialog box appears with the Customize tab selected by default.
-
Select one or more of the check boxes under Options.
Option Description Create log file Record all operations performed during an active Teradata SET session. Use the log file to research an operation. For example, research what occurred during an import operation when the import is partially successful. Log SQL statements Create a log file of the SQL statements used in the export, import, and undo import (cleanup) processes. Display logon dialog at startup Connect automatically to the selected Teradata Database. The Teradata Database Connect dialog box appears. Provide Audible Notification Emit a tone when an event is initiated; for example, when a file is exported. Clickon the toolbar to toggle the audible notification on or off.
Use X views (QCD only) Retrieve data from the QCD using X views. See Creating Restricted Views for information on restricted views.
Use X views (DBC and QCD) Retrieve Data Dictionary information and QCD data using X views. See Creating Restricted Views for information on restricted views.
Use Multi-Threading Speed up export and import operations with multiple connections. Use SQL Assistant instead of the Execute SQL window with ODBC connectivity Use SQL Assistant instead of Execute SQL as the query editor when connected to the Teradata Database with ODBC connectivity. When using a CLIv2 connection, Execute SQL is used regardless of how this option is set.Export table data used by query optimization Export table data used by query optimization along with the execution plan. When this option is selected, table data used by query optimization is retrieved and stored in Teradata SET export files. Table data might be needed to accurately emulate a query plan if the source table of a join has a single-row access using a unique index because the Optimizer retrieves this row and uses the column values for cardinality estimations. Execution plans must be exported in order to use this function. See Export Options for more information on exporting execution plans.Import table data used by query optimization Insert table data used by query optimization to tables on the test system. Capture date specific execution plan information Execution plan information is captured for a specific date when queries using the function CURRENT_DATE are added for export. The Date drop-down list is active when this option is selected. This option works when DUMP EXPLAIN or INSERT EXPLAIN SQL statements are used to capture the execution plan information.
Export Plans in XML For queries entered by user, export execution plans in XML format by submitting INSERT EXPLAIN in XML. Export Dynamic Plans For queries entered by a user, export Dynamic Plans (IPE - Incremental Planning and Execution) captured into the SystemFE.Opt_XMLPlan_Table by submitting DIAGNOSTIC DUMP XMLPLAN SystemName REQUEST RequestName ‘comment string’ ON FOR REQUEST; request; Enable Object Use Count If 'Enable Object Use Count' option is checked, TSET, before importing statistics, will submit REPLACE QUERY LOGGING WITH USECOUNT ON 'DBNAME', where DBNAME is the Database being imported for which OUC information is captured while exporting statistics. And during undo import of statistics, TSET submits END QUERY LOGGING WITH USECOUNT ON 'DBNAME'. The 'Enable Object Use Count' is grayed out when TSET is connected to TD14.0 or earlier versions.
Export Plans in XML and Export Dynamic Plans are mutually exclusive options. Select either option for a manually entered query. Either a dynamic plan or a QCD XML plan can be captured. - Click Apply.
- [Optional] To continue customizing a session, select another tab in the Options dialog box.
- To return to the main window, click OK.