What are the advantages, if any exist, of having an an index for every foreign key in a SQL Server database?
