Why query optimization is necessary? Illustrate on the choices of query execution plans.

Query optimization refers to the process of improving the performance and efficiency of database queries by finding the most effective way to retrieve data. The primary goal is to minimize execution time and resource consumption (CPU usage, disk I/O, and network traffic). The key reasons why quer...