InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is Query Optimization? |
|
Answer» Query optimization is the process of choosing the most efficient execution PLAN. The goal is to achieve the result with least cost in terms of resource usage. Resources INCLUDE I/O and CPU usage on the server where the DATABASE is running. This is a MEANS to reduce the execution times of the query, which is the SUM of the execution times of the all component operations of the query. Query optimization is the process of choosing the most efficient execution plan. The goal is to achieve the result with least cost in terms of resource usage. Resources include I/O and CPU usage on the server where the database is running. This is a means to reduce the execution times of the query, which is the sum of the execution times of the all component operations of the query. |
|