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 Saturday, August 2, 2014 12:24 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 3:13 PM
Points: 614, Visits: 2,678
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
Simple Talk
Post #1598964
Posted Sunday, August 3, 2014 10:24 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 1:27 PM
Points: 18,747, Visits: 16,994
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
Post #1599062
Posted Sunday, August 3, 2014 1:13 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, June 26, 2015 10:24 AM
Points: 5,963, Visits: 13,209
me too, but who's complaining?

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

Post #1599068
Posted Sunday, August 3, 2014 1:16 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 1:27 PM
Points: 18,747, Visits: 16,994
george sibbald (8/3/2014)
me too, but who's complaining?


Me!! Take my points back. I protest!!




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1599071
Posted Sunday, August 3, 2014 2:05 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:03 PM
Points: 1,192, Visits: 3,236
SQLRNNR (8/3/2014)
george sibbald (8/3/2014)
me too, but who's complaining?


Me!! Take my points back. I protest!!

Good question, but I think I'll keep mine
Post #1599074
Posted Sunday, August 3, 2014 4:51 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 5:07 PM
Points: 8,554, Visits: 10,325
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
Post #1599076
Posted Monday, August 4, 2014 12:34 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, June 26, 2015 12:56 AM
Points: 1,011, Visits: 1,754
Nice question, surprisingly too many people still fall for it if you ask them in a interview

Thanks for sharing Phil.

Post #1599122
Posted Monday, August 4, 2014 12:50 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:20 PM
Points: 14,433, Visits: 12,418
Great question, thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1599124
Posted Monday, August 4, 2014 1:21 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, June 26, 2015 12:58 AM
Points: 1,814, Visits: 806
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





Post #1599135
Posted Monday, August 4, 2014 1:22 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:40 AM
Points: 2,853, Visits: 2,727
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.
Post #1599136
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse