On Tuesday 28 October 2008, "JORGE MALDONADO" <jorgemal1960(at)gmail(dot)com>
> I need to define an index for a table but such an index already exists as
> a foreign key.
> I have fk_state (a foreign key) and I need a common index (ix_state).
> Should I define the index or does the foreign key work like an index too?
You need the index. Primary keys and unique constraints are implemented as
indexes, but not foreign keys.
In response to
pgsql-novice by date
|Next:||From: Marcin Krol||Date: 2008-10-29 13:37:50|
|Subject: the cost of logging statements|
|Previous:||From: JORGE MALDONADO||Date: 2008-10-28 20:04:17|
|Subject: FOREIGN KEY AND INDEXEX|