Why is query optimization important?

What are objectives query processing optimization?

• Answer:

  main objective is to retrieve data quickly. Query optimization is the refining process in database administration and it helps to bring down speed of execution. Most of the databases after are built and filled with data, and used come down on speed. The time taken to execute a query and return results exponentially grows as the amount of data increases in the database leading to more waiting times on the user, and application sides. Sometimes the wait times could range from minutes, to hours, and days as well in worst cases. Technically one of the reasons of slow speeds of executions could be excess normalization leading to multiple tables. More the number of tables, more is the complex nature of joins, and thus leading to more execution times. Sometimes, the complex nature of joins could worse the situation by bring the execution into deadlock.