Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Is it possible to alter an FK to make it indexed?
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...
-- jeremyReceived on Tue Aug 31 2004 - 07:16:12 CDT