Question: mssql are foreign keys indexed?
Answer: 3 Answers. SQL Server will not automatically create an index on a foreign key. ... A FOREIGN KEY constraint does not have to be linked only to a PRIMARY KEY constraint in another table; it can also be defined to reference the columns of a UNIQUE constraint in another table.