May 13, 2013 at 3:27 pm
I use SSMS GUI created a FK for a table.
Then later I found there is an index created for that FK.
Does it automatically generate an index for a FK?
I didn't create an index so I am wondering where it comes from?
Thanks
May 13, 2013 at 6:15 pm
Someone had to do it, it's not automatic.
If you're curious, check out this blog from Kimberly Tripp:
When did SQL Server stop putting indexes on Foreign Keys?
MSDN also discusses the value of putting an index on a Foreign Key, since it isn't automatic:
http://msdn.microsoft.com/en-us/library/ms175464(v=sql.105).aspx
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply