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


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 3:40 AM
Points: 588, Visits: 2,554
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: Yesterday @ 8:18 PM
Points: 17,824, Visits: 15,756
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 @ 1:38 AM
Points: 5,879, Visits: 13,010
me too, but who's complaining?

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

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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 8:18 PM
Points: 17,824, Visits: 15,756
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: 2 days ago @ 7:48 PM
Points: 1,057, Visits: 3,127
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:02 PM
Points: 7,801, Visits: 9,553
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
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 781, Visits: 1,390
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 @ 11:42 AM
Points: 13,295, Visits: 11,086
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: Wednesday, October 22, 2014 7:21 PM
Points: 1,762, Visits: 766
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 @ 1:00 AM
Points: 2,563, Visits: 2,420
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