About this document
Understanding Teradata Explain Plan by Seshu Venkat is a document available to read on EtoBox.
The document explains what EXPLAIN is and how it can be used in Teradata. EXPLAIN shows the execution plan for a SQL query, including information like access paths, use of indexes, locking profiles, and estimated runtime. Sample EXPLAIN output is provided for different types of queries, like full table scans, queries using unique primary indexes, non-unique primary indexes, unique secondary indexes, and queries that are redistributed to all Application Message Processors (AMPs). Keywords in EXPLAIN plans li
- Author
- Seshu Venkat
- Language
- EN