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: Tuesday, July 21, 2015 3:36 AM
Points: 616, Visits: 2,689
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 @ 9:03 AM
Points: 18,901, Visits: 17,184
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: Today @ 8:35 AM
Points: 5,977, Visits: 13,220
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 @ 9:03 AM
Points: 18,901, Visits: 17,184
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: Yesterday @ 7:45 PM
Points: 1,199, Visits: 3,240
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 @ 12:51 AM
Points: 8,666, Visits: 10,465
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: Tuesday, July 21, 2015 7:48 AM
Points: 1,023, Visits: 1,783
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: Yesterday @ 6:59 AM
Points: 14,513, Visits: 12,555
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 SQLKover.

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: Thursday, July 23, 2015 8:01 PM
Points: 1,814, Visits: 808
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: Monday, July 20, 2015 4:19 AM
Points: 2,880, Visits: 2,749
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