Re: Bitmap index

Frank Bucher wrote:
>
> Hi all,
>
> we're using Oracle 8.1.7 (NT). I have a prob with bitmap indexes: We
> have a table with approx. 350000 rows and a column with small
> cardinality (3 distinct values). I think a good candidate for a bitmap
> index. Now it starts to get funny:
>
> select /*+ ALL_ROWS */ * from t1 where status <> 'G'
>
> returns 360 rows.
>
> select /*+ FIRST_ROWS */ * from t1 where status <> 'G'
>
> returns 53 rows.
>
> without the bitmnap index both queries return the same (360 rows).
>
> Am I missing here something or shouldn't both queries allways return
> the same, no matter what index or optimizer....
>
> Any help would be appreciated.
>
> TIA
>
> Frank.
>
> Ahh...Could you please mail the answer as well, because im not lurking
> too often.

Sounds likes a bug - if you rebuild the index do you get the error still ?

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."