Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> REPOST: Re: 2 overlapping indexes
Niall wrote :
>> Like Norman I can't for the life of me see the point of adding col4
as the
>> statement is that the first three columns are unique. Unless I have
misread
>> the OP of course.
No, Niall, we are correct, the original poster 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.
But, we know A,B,C is unique, so D cannot make them now non-unique - unless he is using SQL Server :o)
Norman Dunbar EMail: Norman.Dunbar_at_LFS.co.uk Database/Unix administrator Phone: 0113 289 6265 Fax: 0113 289 3146 Lynx Financial Systems Ltd. URL: http://www.Lynx-FS.com ------------------------------------------------------------------------
This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 11:32:28 CST