Search code examples
sqlsql-serversql-server-2008indexingnon-clustered-index

nonclustered index on join

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

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