This chapter describes each message printed by the showplan utility. showplan displays the steps performed for each query in a batch, the keys and indexes used for the query, the order of joins, and special optimizer strategies.