Histogram VS bitmap index

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