Do not create an index when you have defined a FK (which creates an index)

> /* Foreign keys definition */

> ALTER TABLE PART_STOCK ADD CONSTRAINT FK_PART_STOCK__PART_ID FOREIGN
> KEY (PS_PART_ID) REFERENCES PART (PART_ID);
> ALTER TABLE PART_STOCK ADD CONSTRAINT FK_PART_STOCK__WH_ID FOREIGN KEY
> (PS_WH_ID) REFERENCES WAREHOUSE (WH_ID);

> /* Indices definition */

> CREATE INDEX FK_PART_STOCK__PART_ID ON PART_STOCK (PS_PART_ID);
> CREATE INDEX FK_PART_STOCK__WH_ID ON PART_STOCK (PS_WH_ID);

--
Nick
-----We Solve your Computer Problems---
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly



[Non-text portions of this message have been removed]