Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it?

Question

Post reply

Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it?

Phil Factor

SSC-Insane

Points: 20244
More actions
August 2, 2014 at 12:24 pm

#293894

Comments posted to this topic are about the item Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it?
Best wishes,
Phil Factor

Viewing 15 posts - 1 through 15 (of 32 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Really surprised by the point value of this question.

Good fundamental question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

george sibbald SSC Guru Points: 104210 More actions · Answer 2

me too, but who's complaining? 🙂

---------------------------------------------------------------------

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

george sibbald (8/3/2014)
me too, but who's complaining? 🙂

Me!! Take my points back. I protest!! :-D:hehe:;-)

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

mickyT SSChampion Points: 10360 More actions · Answer 4

SQLRNNR (8/3/2014)
george sibbald (8/3/2014)
me too, but who's complaining? 🙂
Me!! Take my points back. I protest!! :-D:hehe:;-)

Good question, but I think I'll keep mine:Whistling::-)

TomThomson SSC Guru Points: 104773 More actions · Answer 5

Just like the others who have commented so far I think this is a good fundamental question which has ben assigned far too many points.

Tom

Umer Akram SSC-Insane Points: 22209 More actions · Answer 6

Nice question, surprisingly too many people still fall for it if you ask them in a interview 😀

Thanks for sharing Phil.

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 7

Great question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 8

TomThomson (8/3/2014)
Just like the others who have commented so far I think this is a good fundamental question which has ben assigned far too many points.

Hope this helps...

Ford Fairlane
Rock and Roll Detective

Carlo Romagnano SSC-Insane Points: 22599 More actions · Answer 9

I read question and answers many times because of high score.

I was searching for the swindle!

But it's only a straightforward basic question.

😀

uravindarreddy Ten Centuries Points: 1390 More actions · Answer 10

Hi,

Yeah this is a very straightforward question but in the context of SQL Server. But will be bit confusing to those who work on other RDBMS products such as MySQL InnoDB. But, for those who work rigorously on MS SQL Server this is just a straightforward question worth of 1 point.

Neil Burton SSC-Insane Points: 22906 More actions · Answer 11

Carlo Romagnano (8/4/2014)
I read question and answers many times because of high score.
I was searching for the swindle!
But it's only a straightforward basic question.
😀

+1

I thought I knew what the answer was as soon as I read the question, then I saw the points value and wondered what the catch was. After a load of research and reading round I found out I was right after all.

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

Phil Factor SSC-Insane Points: 20244 More actions · Answer 12

I'm sorry if it got scored too high, but when I ask this as part of a technical interview, it seems to stump a very large proportion of the candidates. I suspect that it is one of those questions that are either blindingly obvious or impenetrably baffling. And, yes, it could be a trick question for anyone used to some of the other RDBMSs

Best wishes,
Phil Factor

Umer Akram SSC-Insane Points: 22209 More actions · Answer 13

Phil Factor (8/4/2014)
I'm sorry if it got scored too high, but when I ask this as part of a technical interview, it seems to stump a very large proportion of the candidates. I suspect that it is one of those questions that are either blindingly obvious or impenetrably baffling. And, yes, it could be a trick question for anyone used to some of the other RDBMSs

+1000

Gazareth One Orange Chip Points: 27737 More actions · Answer 14

I just thought the easy Q & high points was an attempt to improve everyone's Monday morning 🙂

Can we do this every week?!