Does a foreign key automatically create an index?

by

A foreign key is a constraint, a relationship between two tables – that has nothing to do with an index per se.

But it is a known fact that it makes a lot of sense to index all the columns that are part of any foreign key relationship, because through a FK-relationship, you’ll often need to lookup a relating table and extract certain rows based on a single value or a range of values.

So it makes good sense to index any columns involved in a FK, but a FK per se is not an index.

Check out Kimberly Tripp’s excellent article “When did SQL Server stop putting indexes on Foreign Key columns?”.

More Related Contents:

  1. How to multiply column in Sql
  2. how to select next n letters after one specific letter using function in sql server by giving function name,specific letter, no of letters next
  3. What is the best way to create and populate a numbers table?
  4. Should you choose the MONEY or DECIMAL(x,y) datatypes in SQL Server?
  5. How do you clear the SQL Server transaction log?
  6. Order Of Execution of the SQL query
  7. How Can I Log and Find the Most Expensive Queries?
  8. How to drop a table if it exists?
  9. Connecting to SQL Server LocalDB using JDBC
  10. How to check if a database exists in SQL Server?
  11. How can I do something like: USE @databaseName
  12. SSIS Excel Import Forcing Incorrect Column Type
  13. determining the character set of a table / database?
  14. error when inserting into table having instead of trigger from entity data framework
  15. How to query values from xml nodes?
  16. How to split string and insert values into table in SQL Server
  17. Case sensitive variables in SQL Server
  18. How to query for Xml values and attributes from table in SQL Server?
  19. Full text search does not work if stop word is included even though stop word list is empty
  20. Avg of float inconsistency
  21. Setting up maven dependency for SQL Server
  22. Getting a warning when using a pyodbc Connection object with pandas
  23. In SQL Server, how can I lock a single row in a way similar to Oracle’s “SELECT FOR UPDATE WAIT”?
  24. How can I get the list of tables in the stored procedure?
  25. How to find the boundaries of groups of contiguous sequential numbers?
  26. Generate table relationship diagram from existing schema (SQL Server) [closed]
  27. How does SQL Server decide format for implicit datetime conversion?
  28. Error converting data types when importing from Excel to SQL Server 2008
  29. EAV over SQL Server
  30. The Best Way to shred XML data into SQL Server database columns

Leave a Comment