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

Home -> Community -> Usenet -> c.d.o.server -> Re: indexing a column with only 2 or 3 values

Re: indexing a column with only 2 or 3 values

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: Fri, 03 Aug 2007 03:46:27 -0700
Message-ID: <1186137987.040426.115700@i13g2000prf.googlegroups.com>


On Aug 3, 4:47 am, ciapecki <ciape..._at_gmail.com> wrote:
> It will be actually a view and will be refreshed everyday (once a
> day).
> But thanks for the warning.
>
> BTW. how can you index only N's for example?
>
> chris

Before deciding to use bitmap indexes, you may want to take a look at a couple articles that describe the characteristics of bitmap indexes:

http://jonathanlewis.wordpress.com/2006/11/29/bitmap-indexes/
http://jonathanlewis.wordpress.com/2006/12/19/mything-in-action/
http://www.dbazine.com/oracle/or-articles/jlewis3

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Fri Aug 03 2007 - 05:46:27 CDT

Original text of this message

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