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:
- 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