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 as an aid to help improve query performance further. Analyzing complex query plans can be difficult, so Teradata provides tools to help.
This section discusses:
- Teradata System Emulation Tool (SET), found in Teradata Analyst Pack, designed to help automate and simplify query plan analysis.
- 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