Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> REPOST: 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.
This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Thu Jan 24 2002 - 21:29:09 CST
![]() |
![]() |