REPOST: Re: 2 overlapping indexes

From: miker <mdent12_at_none.com>
Date: Fri, 25 Jan 2002 15:47:15 GMT
Message-ID: <4$--$%%%_$_%_-$-_$@news.noc.cabal.int>

On Fri, 25 Jan 2002 09:39:39 -0000, Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote:

>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.

Record 1 ABCD = X 1 Y 2
Record 2 ABCD = X 1 Y 3

ABCD is unique but ABC is not. If you put a unique index on ABCD then you do not enforce ABC uniqueness. I think the guy wants to enforce unique constrant AND speed up retrieval of ABCD record.

WAS CANCELLED BY =======: From: miker <mdent12_at_none.com> Control: cancel <l9v25ukv31dq4uooc17h3ln60b7imb1o6m_at_4ax.com> Subject: cmsg cancel <l9v25ukv31dq4uooc17h3ln60b7imb1o6m_at_4ax.com> Date: Sun, 27 Jan 2002 23:55:21 GMT Message-ID: <cancel.l9v25ukv31dq4uooc17h3ln60b7imb1o6m_at_4ax.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!feed.news.nacamar.de!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:40722967

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 - 09:47:15 CST