Jeremy <newspostings_at_hazelweb.co.uk> wrote in message news:<MPG.1ba0dae877ac6137989cd5_at_news.individual.net>...
> 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!
Adam Musch
Received on Thu Sep 02 2004 - 12:44:48 CDT
