> create index i_l_partkey on lineitem (l_partkey);
> I do not have any foreign key defined. Does the spec require foreign
> When you create a foreign key reference, does PG create an index
No. A index is not required to enforce a foriegn key, and is sometimes not
useful (for example, FK fields with only 3 possible values).
So it may be that you need to create an index on that field.
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2003-09-26 04:28:54|
|Subject: Re: TPC-R benchmarks |
|Previous:||From: Rod Taylor||Date: 2003-09-25 23:46:41|
|Subject: Re: Indices arent being used|