This chapter describes query processing options that affect the optimizer’s choice of join order, index, I/O size and cache strategy.