This illustration shows a user entering a query, which generates two execution plans. The server then compares the cost of the plan and picks the best.