Re: all foreign key should have index?
From: Tony Rogerson <tonyrogerson_at_sqlserverfaq.com>
Date: Wed, 1 Feb 2006 21:04:18 -0000
Message-ID: <drr7np$p83$1$830fa17d_at_news.demon.co.uk>
Date: Wed, 1 Feb 2006 21:04:18 -0000
Message-ID: <drr7np$p83$1$830fa17d_at_news.demon.co.uk>
Thats a good idea, at the database level.
-- Tony Rogerson SQL Server MVP http://sqlserverfaq.com - free video tutorials <lennart_at_kommunicera.umea.se> wrote in message news:1138809481.959167.5170_at_g44g2000cwa.googlegroups.com...Received on Wed Feb 01 2006 - 22:04:18 CET
>
> 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
>
> [...]
>