Subject RE: [firebird-support] Re: Indexes and Foreign Keys
Author Robert DiFalco
Actually, is that true for Primary Keys? I thought it would create a
composite index for each column that makes up the primary key. However,
if you wanted an index on an individual column that makes up the primary
key, then you have to create that explicitly.


-----Original Message-----
From: Alexander V.Nevsky [mailto:ded@...]
Sent: Monday, July 21, 2003 11:07 AM
Subject: [firebird-support] Re: Indexes and Foreign Keys

--- In, Christian Mautendorfer
<phase-list@g...> wrote:
> Hi,
> Browsing my database I saw that a foreign key constraint also has an
> to go with it.
> This means that there is no reason to create an equivalent Index on
> colum right?

Right. And for Primary Key and Unique constraints too.

Best regards, Alexander.

Yahoo! Groups Sponsor

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.