The Teradata Database Optimizer analyzes steps required to execute each query, then
chooses the most efficient path that returns answers in the minimal amount of time.
The EXPLAIN statement in SQL shows the details of the path chosen by the Optimizer,
and can be used in as an aid to help improve query performance further. Analyzing
complex query plans can be difficult, so Teradata provides tools to help.
This chapter discusses:
Tools found in Teradata Analyst Pack, a set of tools designed to help automate and
simplify query plan analysis. These include:
Teradata Visual Explain (VE)
Teradata System Emulation Tool (SET)
Teradata Index Wizard
Teradata Database Query Analysis Tools (DBQAT), tools designed to improve the overall
performance analysis capabilities of Teradata Database. These include:
Query Capture Facility
Database Query Log
Target Level Emulation (TLE)
Database Object Use Count