The information provided in this discussion is designed to help you to interpret EXPLAIN reports more accurately and to explain and emphasize the importance of maintaining accurate statistical and demographic profiles of your data. This discussion does not describe query optimization in detail.
Join processing is described in Join Planning and Optimization.