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

In article <scs8j05gba0sfois54r9cumndfv7vo1imp_at_4ax.com>, Sybrand Bakker says...
> On Tue, 31 Aug 2004 13:16:12 +0100, Jeremy
> <newspostings_at_hazelweb.co.uk> wrote:
>
> >Version: Oracle 8i (8.1.7.2) / Solaris 2.6
> >

<snip>

> >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...
>
>
> Does the CONSTRAINT clause actually show this? I don't think so!
> Would it be an undocumented clause? Completely unlikely!
>

Well I thought I'd make sure I'd understood the documentation! But to clarify - is it just a convenience to be able to generate the index defintiion as a by-product of the 'add constraint' clause or is there a difference in teh characteristics of the index created this versus the 'create index' method?

If anyone can clarify I'd be very grateful - thanks!

-- 

jeremy