Bitmap index

From: Frank Bucher <frankbucher_at_gmx.de>
Date: 16 Aug 2001 05:08:01 -0700
Message-ID: <f742146.0108160408.31e02ea4@posting.google.com>

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. Received on Thu Aug 16 2001 - 07:08:01 CDT