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.

R.

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


--- In firebird-support@yahoogroups.com, Christian Mautendorfer
<phase-list@g...> wrote:

> Hi,
>
> Browsing my database I saw that a foreign key constraint also has an

Index

> to go with it.
> This means that there is no reason to create an equivalent Index on

that

> colum right?

Right. And for Primary Key and Unique constraints too.

Best regards, Alexander.


Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



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