| From: | Denis Gasparin <denis(at)edistar(dot)com> |
|---|---|
| To: | jeff(at)dgjc(dot)org, Postgresql General Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Indices for foreign keys |
| Date: | 2002-02-04 08:19:51 |
| Message-ID: | 1012810791.2405.2.camel@edspctec12 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I think no.
The foreign key constraint implies a trigger that enforces the
relationship between the tables but no index is created. You'll have to
create it yourself.
Bye
--
Ing. Denis Gasparin: denis(at)edistar(dot)com
---------------------------
Programmer & System Administrator - Edistar srl
Il sab, 2002-02-02 alle 23:04, Jeff Martin ha scritto:
> Are indices automatically created for foreign keys?
>
> Thanks for any help,
>
> Jeff
> Jeff Martin
> 704 Torrey Lane, Apartment D
> Boalsburg, PA 16827
> H814-466-7791
> jeff(at)dgjc(dot)org
> www.dgjc.org
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Milos Prudek | 2002-02-04 10:57:07 | Re: index does not improve performance |
| Previous Message | Lincoln Yeoh | 2002-02-04 07:52:50 | Re: Distributing index's/tables/logs/etc. |