REPOST: Re: 2 overlapping indexes

What is unique on ABC is also unique on ABCD by definition ... even if every value of D is identical.

Daniel Morgan

Keith Boulton wrote:

> Daniel A. Morgan <damorgan_at_exesolutions.com> wrote in message
> news:3C50914E.44C1A427_at_exesolutions.com...
> > To create two different indexes is just adding overhead and serves no
> > useful purpose.
>
> 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.

• WAS CANCELLED BY =======: From: "Daniel A. Morgan" <damorgan_at_exesolutions.com> Control: cancel <3C512D0B.7CC8956B_at_exesolutions.com> Subject: cmsg cancel <3C512D0B.7CC8956B_at_exesolutions.com> Date: Mon, 28 Jan 2002 00:58:28 GMT Message-ID: <cancel.3C512D0B.7CC8956B_at_exesolutions.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!blackbush.xlink.net!blackbush.de.kpnqwest.net!newsfeed.freenet.de!amsnews01.chello.com!trev!newsfeed.esat.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40722293

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 - 04:01:47 CST