Box 1: Clustered Index
With the same size of keys, the nonclustered indexes need more space than clustered
Box 2, Box 3:
Include the CustomerStatus column in the index, and only when CustomerStatusnot equal to 1
(the active customers).
You are developing an application that connects to a database.
The application runs the following jobs: