Which of the following is a disadvantage of dynamic SQL ?
A. Stored procedure can not cache the execution plan for this dynamic query
B. Stored procedure can cache the execution plan for this dynamic query
C. Flexability in your code that you can not get with standard SQL
D. All of the mentioned
Answer:A
Which of the following is a disadvantage of dynamic SQL ?
A. Stored procedure can not cache the execution plan for this dynamic query B. Stored procedure can cache the execution plan for this dynamic query C. Flexability in your code that you can not get with standard SQL D. All of the mentioned
Explanation:Stored procedure can not cache the execution plan for this dynamic query. So, for complex queries you will lose a the performance boost that you usually gain with stored procedures.