Select from following answers:- Create two clustered indexes, one on region and one on status.
- Create compsite clustered indexes on region and on status.
- Create composite nonclustered indexes on region and status
- All Above
A table can have only 1 clustered index. A nonclustered index on columns frequently used in a where clause can improve query performance.
Show Correct Answer
|
Alert Moderator