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.
Option A
B.
Option B
C.
Option C
D.
Option D
I think it should be C.
It is A. Using the cast or convert function on column will prevent use of index. You should convert the parameter data types to match column’s.