On 2010-06-24, Jean-Yves F. Barbier <12ukwn(at)gmail(dot)com> wrote:
> Hi list,
> does a Referential Integrity toward a table also acts like an index, or
> am I obliged to create this index?
The RI does not create any indices.
There is no requirement to create an index.
In most cases creating an index at one or both ends or the reference
is a good idea.
In response to
- RI at 2010-06-24 03:19:12 from Jean-Yves F. Barbier
- Re: RI at 2010-06-24 04:48:18 from Tom Lane
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2010-06-24 04:48:18|
|Subject: Re: RI |
|Previous:||From: Jean-Yves F. Barbier||Date: 2010-06-24 03:19:12|