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

Home -> Community -> Mailing Lists -> Oracle-L -> Histogram VS bitmap index

Histogram VS bitmap index

From: Luc Demanche <ldemanch_at_cetelem.fr>
Date: Fri, 26 May 2000 11:36:56 +0200
Message-Id: <10509.106836@fatcity.com>


Hello,

I have an EMP table with a field named GENDER. The only two possibilities
for this field is M or F.

What is the best strategy for the cost optimizer between:

1- Create a column histogram on GENDER
2- Create a bitmap index on GENDER

We don't use bind variables for GENDER (important for histogram).

Thanks in advance. Received on Fri May 26 2000 - 04:36:56 CDT

Original text of this message

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