Re: Foreign Key + Index

From: Henri (hmfireball_at_hotmail.com)
Date: 02/16/05 

Date: Wed, 16 Feb 2005 01:05:33 +0100

Thanks for your answer Greg :-)

"pdxJaxon" <GregoryAJackson@Hotmail.com> a écrit dans le message de
news:OMI0r%234EFHA.3200@TK2MSFTNGP10.phx.gbl...
> a Foreign Key is NOT automatically indexed in SQL Server.
>
> you'll need to index it.
>
>
> Greg Jackson
> Portland, OR
>
>
>

Relevant Pages

  • Re: Cascading Changes in SQL Server
    ... is this article saying that SQL server ... >> relationship had cascading deletes and updates. ... or modify other FOREIGN KEY constraints. ...
    (microsoft.public.sqlserver.server)
  • MS SQL Server - a plethora of limitations...
    ... there are limitations in SQL Server, ... still cannot produce a decent version of MS SQL Server, ... No create or replace for functions / procs. ... > RefID1 int not null foreign key references ForKey ...
    (microsoft.public.sqlserver.programming)
  • Re: Cascading Referential Integrity Constraints
    ... That functionality won't be available until the next release of SQL Server ... I have the foreign key set to ... always delete the detail/many records when the master/one record is deleted. ...
    (microsoft.public.sqlserver.server)
  • Re: Do foreign keys generate implicit indexes?
    ... SQL Server does not automatically index foreign key columns. ... That task is left to the discretion of the DBA, who might choose not to index the foreign columndue to low cardinality and static data. ...
    (comp.databases.ms-sqlserver)
  • Re: Best way to represent a many to many with optionality?
    ... DELETE Rules of the foreign key to enforce the above mentioned "business rules" without getting the "circularity/default" errors? ... SQL Server lets you specify any of the following rules to apply to either INSERT/UPDATE or DELETE: ... CustomerID bigint NOT NULL identity ... AddressTypeID tinyint NOT NULL ...
    (microsoft.public.sqlserver.programming)