Re: 2 overlapping indexes

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Fri, 25 Jan 2002 10:04:38 +0000
Message-ID: <3C512DB6.5C87ACAC@exesolutions.com>

I agree. But I don't see the relevance of the statement to the poster's question.

There is nothing you can do with an ABC index you can not do with an ABCD index.

Daniel Morgan

Brian Tkatch wrote:

> On Thu, 24 Jan 2002 22:57:18 +0000, "Daniel A. Morgan"
> <damorgan_at_exesolutions.com> wrote:
>
> >Just build the unique index on ABCD: Oracle will use the ABC or the ABCD
> >as it needs it. Though you should verify with EXPLAIN PLAN.
> >
> >To create two different indexes is just adding overhead and serves no
> >useful purpose.
> >
> >Daniel Morgan
>
> Allowing a composite FOREIGN KEY may be a useful purpose. Sometimes
> needed when keepig four table synchronized.
>
> Brian
Received on Fri Jan 25 2002 - 04:04:38 CST