Re: all foreign key should have index?

From: <lennart_at_kommunicera.umea.se>
Date: 1 Feb 2006 07:58:02 -0800
Message-ID: <1138809481.959167.5170@g44g2000cwa.googlegroups.com>

Tony Rogerson wrote:
> Good point, but I'd rather have the control, consider a trading table that
> you don't delete from as one example, there are dozens of others.
>

Another point worth mentioning is that one sometimes want to create indexes with physical details like PCTFREE, CLUSTER etc. Atleast DB2 complains that it will not create an index for you, if there already is an index on the same columns. Perhaps a DB or DBMS cfg parameter that determined whether index are auto created or not would be nice.

/Lennart

[...] Received on Wed Feb 01 2006 - 09:58:02 CST