17.10 - Join Planning and Optimization - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Request and Transaction Processing

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
User Guide
Publication ID
B035-1142-171K
Language
English (United States)

This section provides information about fundamentals of join planning and a cross section of join optimizations. Note that not all optimizations are described. Use an EXPLAIN to see a summary of the optimizations done for your queries.

The information provided is designed to help you to interpret EXPLAIN reports more accurately, and provides some recommendations for how you can improved your plans. For more information about how to optimize the performance of your database from other perspectives, see Teradata Vantageā„¢ - Database Design, B035-1094.