REPOST: Re: 2 overlapping indexes

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Thu, 24 Jan 2002 22:57:18 +0000
Message-ID: <6$--$%%%%--%-$-$_$@news.noc.cabal.int>

Just build the unique index on ABCD: Oracle will use the ABC or the ABCD as it needs it. Though you should verify with EXPLAIN PLAN.

To create two different indexes is just adding overhead and serves no useful purpose.

Daniel Morgan

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

WAS CANCELLED BY =======: From: "Daniel A. Morgan" <damorgan_at_exesolutions.com> Control: cancel <3C50914E.44C1A427_at_exesolutions.com> Subject: cmsg cancel <3C50914E.44C1A427_at_exesolutions.com> Date: Mon, 28 Jan 2002 01:35:11 GMT Message-ID: <cancel.3C50914E.44C1A427_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!cert.uni-stuttgart.de!news.belwue.de!news.uni-ulm.de!rz.uni-karlsruhe.de!blackbush.xlink.net!blackbush.de.kpnqwest.net!newsfeed.media.kyoto-u.ac.jp!hub1.nntpserver.com!xmission!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40724332

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Thu Jan 24 2002 - 16:57:18 CST