— List all Foreign Keys
SELECT name, is_not_trusted
FROM sys.foreign_keys
— These are trusted by the database.
— They will be used for JOINs and result in INDEX SEEK or INDEX SCAN efficiency
SELECT name, is_not_trusted
FROM sys.foreign_keys
WHERE is_not_trusted = 0
— These are not trusted by the database.
— They will result in table scans on all JOIN SQL – very inefficient
SELECT name, is_not_trusted
FROM sys.foreign_keys
WHERE is_not_trusted = 1