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
                            
                        
                                            
                             Login                        
                    
                        0 Comments                    
                                        
                     Inline Feedbacks                    
                    View all comments
                 
	