Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> REPOST: Re: 2 overlapping indexes
I must be missing the point here :
id A,B,C are unique then surely A,B,C,D *must* also be unique if the columns are in that order.
Hence, only a single unique index on A,B,C,D is needed by the original poster.
Regards,
Norman.
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 ------------------------------------------------------------------------
-----Original Message-----
From: Keith Boulton [mailto:kboulton_at_ntlworld.com]
Posted At: Friday, January 25, 2002 7:58 AM
Posted To: server
Conversation: 2 overlapping indexes
Subject: Re: 2 overlapping indexes
>> Except to enforce the uniqueness of A,B,C - which I would consider a
useful
>> purpose.
> > 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.
No.
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 - 03:39:39 CST