On Tue, 2005-08-23 at 10:30 -0400, Emi Lu wrote:
> I'd like to setup foreign key constraint for A.col3, as the following:
> CONSTRAINT Aclo3_fk FOREIGN KEY (col3) REFERENCES B(colB1)
>
> But I got a warning msg from postgresql as:
>
> foreign key constraint "Aclo3_fk" will require costly sequential
> scans
Index the foreign key:
create index a_col3_ix on a (col3);
and then drop an recreate the foreign key and see if the warning is
still there.
As a rule I index foreign keys.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
