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: Today @ 8:41 AM
Points: 621, Visits: 2,710
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 @ 3:31 PM
Points: 19,175, Visits: 17,474
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: Yesterday @ 1:39 PM
Points: 5,986, Visits: 13,248
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 @ 3:31 PM
Points: 19,175, Visits: 17,474
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: Monday, July 27, 2015 7:45 PM
Points: 1,205, 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:58 PM
Points: 8,745, Visits: 10,573
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: Wednesday, August 26, 2015 11:19 PM
Points: 1,031, Visits: 1,809
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: 2 days ago @ 9:12 AM
Points: 14,608, Visits: 12,669
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: Friday, August 21, 2015 1:27 AM
Points: 1,817, Visits: 821
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: 2 days ago @ 2:11 AM
Points: 2,909, Visits: 2,787
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