Uses Imported Data
Capturing data from a target (production) system and applying it to a test system is a two‑phase process:
1 Relevant data on the target system is read and then written to a staging area.
2 The staged data is imported to the test system and applied to the appropriate data tables.
Imported data is used to:
Note: The Optimizer generates query execution plans based on many factors, such as available system resources, indexes, primary and secondary keys, and available statistics. All of these factors impact how the Optimizer creates the most effective execution plan.
Note: A small test system can be used to generate query plans that emulate a much larger target system.
Teradata SET also works with Teradata Visual Explain to emulate how a target system performs under specific conditions and workloads.