You need to reduce the amount of time it takes to execute Proc1

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?

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’.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Willem Jan

Willem Jan

The answers do not belong to the question