Re: all foreign key should have index?

Tony Rogerson wrote:
> That would be a look up on the primary key though, rather, the key you've
> reference on the foreign key clause....
>
> So in this example...
>
> create table test2 (
> mycol_id int not null constraint pk_test2 primary key clustered
> )
>
> create table myothertable (
> blah int not null constraint pk_myothertable primary key clustered,
> mycol_id int not null references test2 ( mycol_id )
> )
>
> What is the point of indexing mycol_id?
>

delete from test2 where ...

/Lennart

[...] Received on Tue Jan 31 2006 - 13:45:33 CST