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