Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 2 overlapping indexes
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 - 11:28:13 CST