The optimizer has various access paths to consider when creating the execution plan, each with unique advantages and disadvantages. This ...