2 overlapping indexes

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 - 21:29:09 CST