You have database table named purchaseHistory that contains million of rows. The table have primary key name purcharseId. User frequently use a query that includes the region and status column, with the where clause condition. Your task is to improve the performance of this query?

 Posted by Rajkatie on 12/18/2015 | Category: Sql Server Interview questions | Views: 3112 | Points: 40
Select from following answers:
  1. Create two clustered indexes, one on region and one on status.
  2. Create compsite clustered indexes on region and on status.
  3. Create composite nonclustered indexes on region and status
  4. All Above

Show Correct Answer


| Alert Moderator 

Comments or Responses

Login to post response