Why will preparing UPDATE and DELETE statements increase their execution speed?

Why will preparing UPDATE and DELETE statements increase their execution speed?
A . UPDATE and DELETE statements can NOT be prepared.
B . The rows of the tables being selected will be cached in memory if the statement is prepared.
C . Prepared statements are checked for syntax and optimized at prepare time, not at execution time.
D . Memory is allocated for the results set which will be returned from the SELECT statement at prepare time.

Answer: C

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments