Query and Database Analysis Tools - Advanced SQL Engine - Teradata Database

Database Introduction

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
jiv1600056352873.ditamap
dita:ditavalPath
jiv1600056352873.ditaval
dita:id
B035-1091
lifecycle
previous
Product Category
Teradata Vantageā„¢

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