Re: Is it possible to alter an FK to make it indexed?

Jeremy wrote:

> Version: Oracle 8i (8.1.7.2) / Solaris 2.6
>
> Unindexed FKs are generally a 'bad thing' (although I recognise this is
> not necessarily always so) - for one thing performance can be affected
> and another is that deadlocks may become more likely.
>
> Is there an alter table statement that can be issued to modify an FK
> constraint to specify that an index should be used? I believe this is
> possible when using the 'ADD constraint' clause of alter table just.
>
> If so, is there any difference between doing that and simply issuing a
> 'create index' statemet for the FK column?
>
> Thanks...
>

No Not that i know of.

-- 

Cheers
Ganesh Raja
ganesh.raja_at_nospam.mantas.com
<Remove nospam to Mail>