Why do we need to use over optimization in SQL?

A completely different solution is discovered that renders this unneeded. Over-optimization sounds good, but in the context of resource management is generally wasteful. A giant (but unnecessary) covering index will cost us computing resources whenever we write to a table for the rest of eternity (a long time).
For More Information Please Refer:
You May Also Like to Read: