Re: Foreign Key + Index

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: pdxJaxon (GregoryAJackson_at_Hotmail.com)
Date: 02/15/05

Next message: Sue Hoegemeier: "Re: Unknown Query Engine Error"
Previous message: gopi: "Re: Transaction Log Questions"
In reply to: Henri: "Foreign Key + Index"
Next in thread: Henri: "Re: Foreign Key + Index"
Reply: Henri: "Re: Foreign Key + Index"
Messages sorted by: [ date ] [ thread ]

Date: Tue, 15 Feb 2005 10:54:00 -0800

a Foreign Key is NOT automatically indexed in SQL Server.

you'll need to index it.

Greg Jackson
Portland, OR

Next message: Sue Hoegemeier: "Re: Unknown Query Engine Error"
Previous message: gopi: "Re: Transaction Log Questions"
In reply to: Henri: "Foreign Key + Index"
Next in thread: Henri: "Re: Foreign Key + Index"
Reply: Henri: "Re: Foreign Key + Index"
Messages sorted by: [ date ] [ thread ]

www.tech-archive.net > Archive > SQL-Server > microsoft.public.sqlserver.server > 2005-02