Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: side effect of compound index

Re: side effect of compound index

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 20 Apr 2006 09:19:06 -0700
Message-ID: <1145549941.411825@yasure.drizzle.com>


Anne Lendrow wrote:
> Hi,
>
> we are currently struggling with quite a slow SQL-Statement. When we use
> a Bitmap Index on 3 fields of the table, the SQL-Statement needs to
> finish its operation approximately 30 seconds.
> Now we changed the composite index to cover 4 fields and is not
> bitmapped. The SQL-Statement is now finished in < 1 second.
>
> In fact, the cardinality of the fourth, new field is high, the usage of
> a Bitmap Index wouldn't be a good idea, but maybe using this new
> composite index (4 fields instead of 3, where the cardinality of the 3
> fields of the old index is low) will have other side effects. Could you
> please help me to figure out these side-effects?
>
> Thanks for your help,
> Anne

Likely the only side effect will be better running queries.

Every time you make a change like this you should be running an EXPLAIN PLAN and documenting the effect.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Apr 20 2006 - 11:19:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US