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:
https://www.sqlshack.com/query-optimization-techniques-in-sql-server-the-basics/
You May Also Like to Read: