Which of the following is true about access plan execution?
A) Machine code generated from the access plan executes faster than interpreting the access plan
B) The difference in execution time of machine code and of interpretation is usually small for most users
C) DBMS usually interpret access plan rather than generate machine code because of the great variety of hardware
D) All of the above

Question

Quizplus · Accepted Answer

All of the statements are true regarding access plan execution. Machine code generated from the access plan does execute faster than interpreting the access plan directly because it is optimized for the specific hardware it runs on. However, for most users, the difference in execution time might not be significant due to the efficiency of modern DBMS interpreters and the nature of the queries being executed. DBMSs often interpret access plans rather than compile them into machine code due to the wide variety of hardware configurations they must support, making it impractical to generate optimized machine code for each possible scenario.

Which of the Following Is True About Access Plan Execution