Access path are depend on the statement WHERE clause and it’s FROM clause. Optimizer generates possible execution plans and estimates the cost of each plan using statistics. Finally optimizer chooses execution plan with the lowest estimated cost.