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_at_news.demon.co.uk>
Date: Tue, 31 Jan 2006 14:37:10 -0000
Message-ID: <drnsls$snq$1$8300dec7_at_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?
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...Received on Tue Jan 31 2006 - 15:37:10 CET
>>> 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.
>