Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> REPOST: Re: 2 overlapping indexes

REPOST: Re: 2 overlapping indexes

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 25 Jan 2002 09:39:39 -0000
Message-ID: <3$--$%%%_$$_%-_$-$@news.noc.cabal.int>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US