REPOST: Re: 2 overlapping indexes

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: "Keith Boulton" <kboulton_at_ntlworld.com> Control: cancel <x9848.19980$Ph2.3366055_at_news2-win.server.ntlworld.com> Subject: cmsg cancel <x9848.19980$Ph2.3366055_at_news2-win.server.ntlworld.com> Date: Mon, 28 Jan 2002 02:54:39 GMT Message-ID: <cancel.x9848.19980$Ph2.3366055_at_news2-win.server.ntlworld.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!news.fh-hannover.de!unlisys!news.snafu.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.frii.com!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40723675

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 - 01:57:37 CST