You review a query that runs slowly. The query accesses data in a table named
Schema1.Table1.
The following is the relevant portion of the execution plan for the query:
You need to create the missing index.
Which code segment should you execute?
A.
CREATE NONCLUSTEREDINDEX 1X1 on Schema1-
Table1(Column1)INCLUDE(Column4) WHERE Cclumn2 <> Column3
B.
CREATE NONCLUSTEREDINDEX 1X1 on Schema1.Table1(Column1)
C.
CREATE NONCLUSTEREDINDEX 1X1 on Schema1.Table1(Column1,Column2,
Column3) INCLUDE(Column1)
D.
CREATE NONCLUSTEREDINDEX 1X1 on
chema1.Table1(Column1)INCLUDE(Column4)