Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it? Expand / Collapse
Author
Message
Posted Tuesday, August 5, 2014 12:50 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:46 AM
Points: 1,257, Visits: 597
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
Post #1599482
Posted Tuesday, August 5, 2014 2:05 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 8:11 AM
Points: 270, Visits: 236
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.
Post #1599504
Posted Tuesday, August 5, 2014 6:44 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:39 AM
Points: 2,935, Visits: 239
Thanks for the question.
Post #1599661
Posted Tuesday, August 5, 2014 10:01 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, September 15, 2014 11:54 AM
Points: 4,427, Visits: 3,423
Nice and easy... Thanks, Phil!
Post #1599828
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse