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 17:32:28 -0000
Message-ID: <4$--$%%%_$$_%-_$-$@news.noc.cabal.int>


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

Original text of this message

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