Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 2 overlapping indexes

Re: 2 overlapping indexes

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Thu, 24 Jan 2002 22:57:18 +0000
Message-ID: <3C50914E.44C1A427@exesolutions.com>


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

cj wrote:

> I have a table with column A, B, C, D and E. The data is unique on A,
> B and C so I create a unique index on that. Now I would also like to
> create a non-unique index on A, B, C and D. Is there a space
> efficient way of doing it by declaring table constraint on A, B and C
> and then using the index with A,B,C and D? TIA.
Received on Thu Jan 24 2002 - 16:57:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US