You have a SQL Server 2012 database named Database1.
You execute the following code:
You insert 3 million rows into Sales.
You need to reduce the amount of time it takes to execute Proc1.
What should you do?
A.
ProductType varchar(11) ‘@ProductType’,
B.
ProductType varchar(11) ‘ProductType/ID’,
C.
ProductType varchar(11) ‘ProductType/@ID’,
D.
ProductType varchar(11) ‘ProductType1’.
The answers do not belong to the question
See the right Answers in Question 48
http://www.aiotestking.com/microsoft/you-need-to-reduce-the-amount-of-time-it-takes-to-execute-proc1-3/