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

Question

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

Viewing 2 posts - 31 through 32 (of 32 total)

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

manik_anu SSCrazy Points: 2397 More actions · Answer 1

nice question... i got 4 points

Clustered Index will created for second table only not for first table. Other wise we can create non clustered index for the first table which have foreign key constraint.

Manik
You cannot get to the top by sitting on your bottom.

Revenant SSC-Forever Points: 42467 More actions · Answer 2

Revenant

SSC-Forever

Points: 42467

August 5, 2014 at 10:01 am

#1735295

Nice and easy... Thanks, Phil!

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

Cookies on SQLServerCentral