Candidate Indexes on an “OrderLine” SQL table
Simplified “OrderLine” SQL table showing two candidate unique indexes (an integer surrogate key and a key formed by concatenating two columns) and two candidate non-unique indexes for foreign keys.
The two unique indexes can be contrasted to illustrate the effect of choosing alternative clustered indexes.