Teradata SET imitates a target (production) system on a test system. System-level environmental data is captured from the target system, then stored in relational tables. The Teradata Query Optimizer (Optimizer) processes information from these tables, together with appropriate column and index statistics, to generate query plans on the test system as though the operation occurred in the production environment.
Use Teradata SET to do the following:
- Imitate the impact of environmental changes on Structured Query Language (SQL) statement performance.
- Determine the source of Optimizer-based query issues using imported environmental cost data and random AMP sample (RAS)-based statistical data.
Teradata SET performs the following key functions:
- Works as a standalone application.
- Interfaces with a database using CLIv2 or ODBC.
- Exports system information from a target system to a specified file on a workstation.
- Imports system information from the workstation to a test system.
- Displays the Query, Explain Text, Step Report, and Summary Information for queries in the Import window.
- Allows editing of object definitions, statistics, RAS, cost parameters, and cost profiles before import to a test system.
- Exports and imports data demographics of tables from one Query Capture Database (QCD) to another.
- Provides a summary report of the failures and successes of an import, export, or undo (cleanup) operation.
- Allows visual reordering of databases.
- Exports and imports Native Object Store (NOS) tables and related objects such as authorization and CSV schema. There is no difference in the user experience as the application does not differentiate between normal and NOS tables.
- Exports and imports workload recommendations.
- Allows other client applications to use Teradata SET functions.