InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is Query Execution? |
|
Answer» During the final STAGE of a query processing, the optimized query(the physical query plan that has been selected) is executed. If it's a SELECT statement the rows are RETURNED to the user. If it's an INSERT,UPDATE or DELETE statement ,the rows are MODIFIED. The SQL execution engine takes the execution plan provided by the OPTIMIZATION phase and executes it. During the final stage of a query processing, the optimized query(the physical query plan that has been selected) is executed. If it's a SELECT statement the rows are returned to the user. If it's an INSERT,UPDATE or DELETE statement ,the rows are modified. The SQL execution engine takes the execution plan provided by the optimization phase and executes it. |
|