Chapter 36: Using set showplan
Messages describing access methods, caching, and I/O cost
showplan
output provides information about access methods and caching strategies.