Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-07 : 09:02:51
|
| Sergey writes "There is a field in the table that refer to primary key of another table by foreign key relation. Should I add an index to this field to speed up the query or the foreign key reference is enough? Does the foreign key reference create an index implicitly in MSSQL2000?" |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-03-07 : 09:12:28
|
| No, foreign key does not create an index automatically, so indexing a foreign key field is usually a good idea. |
 |
|
|
|
|
|
foreign key and indexing