When Target Level Emulation (TLE) information is stored on a test system, Teradata System Emulation Tool (SET) enables you to generate and examine the query plans using the test system Optimizer as if the plans were processed on the production system.
Using Teradata SET you can do the following:
- Change system configuration details, including DBS Control fields and table demographics.
- Model the impact of changes on SQL statement performance.
- Determine the source of Optimizer-based production problems.