REPOST: Re: 2 overlapping indexes

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Fri, 25 Jan 2002 17:28:13 GMT
Message-ID: <3$--$%%%%----$_$$$@news.noc.cabal.int>

On Thu, 24 Jan 2002 22:57:18 +0000, "Daniel A. Morgan" <damorgan_at_exesolutions.com> wrote:

>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

Allowing a composite FOREIGN KEY may be a useful purpose. Sometimes needed when keepig four table synchronized.

Brian

WAS CANCELLED BY =======: From: SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK (Brian Tkatch) Control: cancel <3c519570.1504705891_at_news.alt.net> Subject: cmsg cancel <3c519570.1504705891_at_news.alt.net> Date: Sun, 27 Jan 2002 23:54:57 GMT Message-ID: <cancel.3c519570.1504705891_at_news.alt.net> 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!fu-berlin.de!news.maxwell.syr.edu!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:40722511

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:28:13 CST