If a table has a concatenated primary key (Col_A, Col_B) and is a clustered index where each column is a foreign key from another parent table, would it be necessary to create nonclustered indexes on each individual key (one on Col_A and another on Col_B)? Or, would SQL Server use the clustered index of this table when joined to the child table efficiently?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Indexing Question
- Thread starter bbitzer
- Start date
- Status
Similar threads
