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