You have a table named Books that contains information about books. Books has the
columns in the following table. You plan to create several queries that will filter on Title and
ISBN. The queries will return values from Title, ISBN, and Description. You need to
recommend an indexing solution to meet the following requirements: ·Minimize the amount
of time required to return the results of the planned queries ·Minimize the number of indexes
What should you recommend?
A.
Create a nonclustered index on each column.
B.
Create a clustered index on Title, ISBN and Description as the key value.
C.
Create a clustered index on Title and ISBN and set the index fill factor to 75.
D.
Create a nonclustered index on Title and ISBN and include the Description column.