You are a database developer. You plan to design a database solution by using SQL Server 2008. The database application has a table named Transactions that contains millions of rows. The table has multiple columns that include transaction_id and transaction_date. There is a clustered index on the transaction_id column. There is a nonclustered index on the transaction_date column. You discover that the following query takes a long time to execute. You need to ensure that the query retrieves data in minimum possible time. What should you do?

Question

Accepted Answer

D. Create a nonclustered index on the transaction_date and transaction_type_id columns and

Answer

A. Create a nonclustered index on the transaction_type_id column.

Answer

B. Create a nonclustered index on the transaction_date and transaction_type_id columns.

Answer

C. Create a nonclustered index on the transaction_date column and include the

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database application has a table named Transactions that contains millions of rows. The table has…

Question

Exhibit

Options

How the community answered

Community Discussion