Mid SQL Cost Estimation: The optimizer estimates the cost of using each index (in terms of? I/O, CPU, etc.) and chooses the one with the lowest cost.