SQL Script to create indexes for Foreign keys
http://stackoverflow.com/questions/278982/are-foreign-keys-indexed-automatically-in-sql-server
I've used SQL script similar to paul_nielsen's to Create Indexes for Foreign Keys and added “if not exists” condition
DECLARE @SQL VARCHAR(max); SET @SQL = ''
SELECT @SQL = @SQL +
'if not exists (select...
[read more]
Submit a review:
Login required.