View Single Post

   
  #8 (permalink)  
Old 02-26-2008, 07:25 AM
Charles Hooper
 
Posts: n/a
Default Re: indexing a column with only 2 or 3 values

On Aug 3, 4:47 am, ciapecki <ciape...@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/2...itmap-indexes/
http://jonathanlewis.wordpress.com/2...ing-in-action/
http://www.dbazine.com/oracle/or-articles/jlewis3

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.

Reply With Quote