nonclustered index on join

indexing, non-clustered-index, sql, sql-server, sql-server-2008

Solution

You definitely need to put non-clustered index on foreign-key column:

Read more:

http://www.sqlperformance.com/2012/11/t-sql-queries/benefits-indexing-foreign-keys

Problem

I have been wondering if having nonclustered index on the join would improve performance?? like ``` INNER JOIN FaceList fl ON fl.FaceListID = flf.FaceListID ``` in above join can I get performance benefit when I have nonclustered index on FaceListID since its unique combination and return a definite result Any link or suggestion is appreciated

Original source