Explanation:SET SHOWPLAN_TEXT causes Microsoft SQL Server not to execute Transact-SQL statements. 9. The way that a statement can be physically executed is called :
A. query plan
B. execution plan
C. query execution plan
D. All of the mentioned
Answer:A
Explanation:SET SHOWPLAN_TEXT causes Microsoft SQL Server not to execute Transact-SQL statements. 9. The way that a statement can be physically executed is called :
A. query plan B. execution plan C. query execution plan D. All of the mentioned
Explanation:An execution plan is composed of primitive operations. Examples of primitive operations are: reading a table completely, using an index, performing a nested loop or a hash join. 10.SET SHOWPLAN_TEXT is intended to return readable output for ________ utility.