REPOST: Re: 2 overlapping indexes

If you are using Oracle8i the simple solution is to create an index on A,B,C,D, either unique of non-unique, and then create a unique constraint on A,B,C. Oracle will use the existing index to enforce your unique constraint since the leading columns in your index are the same as you want in your constraint. If your DB is still pre-Oracle8i you are out of luck.

cjestrada2_at_yahoo.com (cj) wrote in message news:<432b083a.0201241929.7c3405a6_at_posting.google.com>...
> 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: dyou98_at_aol.com (D.Y.) Control: cancel <f369a0eb.0201250825.77c0a3c4_at_posting.google.com> Subject: cmsg cancel <f369a0eb.0201250825.77c0a3c4_at_posting.google.com> Date: Mon, 28 Jan 2002 03:01:50 GMT Message-ID: <cancel.f369a0eb.0201250825.77c0a3c4_at_posting.google.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!uni-erlangen.de!news-nue1.dfn.de!newsfeed.r-kom.de!newsfeed.stueberl.de!newsfeed.online.be!newsfeed.esat.net!nntp.cifnet.net!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:40722811

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 - 10:25:56 CST