Re: indexing a column with only 2 or 3 values

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