Indexes Supporting Foreign Keys

Most developers building an OLTP system know that you should declare and enforce relationships between tables using Foreign Keys.  But what physical database structures should you implement to support those relationships?  Every Foreign Key is a relationship from one or more columns on the table on which the Foreign Key is declared to a Key…

1