Home Forums Article Discussions Article Discussions by Author Discuss content posted by Phil Factor Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it? RE: Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it?

  • 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.