15.00 - 15.10 - Chapter 15 Query and Database Analysis Tools - Teradata Database

Teradata Database Introduction to Teradata

Product
Teradata Database
Release Number
15.00
15.10
Content Type
User Guide
Publication ID
B035-1091-151K
Language
English (United States)
Last Update
2018-09-25

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