A foreign key is a column or combination of columns in a relational table that matches a candidate key of another table. The foreign key can be used to cross-reference tables.

- Stackoverflow.com Wiki
1 articles, 0 books.

SQL Server has NEVER put an index on a foreign key column… Indexes are used to make the lookup (in a primary or unique key) for a duplicate value FAST.