Post reply

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

  • August 5, 2014 at 12:50 am

    #1735006

    BWFC (8/4/2014)

    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.

    Same here 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • August 5, 2014 at 2:05 am

    #1735025

    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.

  • August 5, 2014 at 10:01 am

    #1735295

    Nice and easy... Thanks, Phil!

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

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