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