Re: all foreign key should have index?

From: Tony Rogerson <tonyrogerson_at_sqlserverfaq.com>
Date: Tue, 31 Jan 2006 14:37:10 -0000
Message-ID: <drnsls$snq$1$8300dec7@news.demon.co.uk>

> No. But better SQL products construct a "PK=FK" index under the
> covers for you.

Do you have a list of those?

Is it configurable? I'm not sure I want my rdbms generating a 5GB index on my foreign key when I might not require it.

Backup bloat to start with.

-- 
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"-CELKO-" <jcelko212_at_earthlink.net> wrote in message 
news:1138687059.234890.22280_at_g47g2000cwa.googlegroups.com...


>>> Is it necessary that all foreign key should have index? <<

>

> No.  But better SQL products construct a "PK=FK"  index under the

> covers for you.

>

Received on Tue Jan 31 2006 - 08:37:10 CST