Home Forums Article Discussions Article Discussions by Author Discuss content posted by Alok Dwivedi An Un-indexed Foreign Key Gotcha RE: An Un-indexed Foreign Key Gotcha
richardd
Hall of Fame
Points: 3963
More actions
November 9, 2009 at 6:35 am
#1076627
Great catch!
Paul Nielsen posted a script back in 2007 to auto-generate indexes for foreign keys:
http://sqlblog.com/blogs/paul_nielsen/archive/2007/02/08/codegen-to-create-indexes-for-fks.aspx
http://www.sqlserverbible.com/scripts.htm