Re: Bitmap index usage...

From: Tim Nickason <tnickasn_at_rogers.wave.ca>
Date: 1997/11/23
Message-ID: <658qd8$hto$1@news.bc>#1/1

Greetings,

Hi have this problem before as well. Oracle support said it was due to bugs in the
optimizer. I run version 7.3.2.3 on Dec unix. BTW: I'm not sure what version you are using
but Oracle support said the version I run does not offically support bitmap indexes.
You need to be on 7.3.3. This may be your problem. Assuming you done analyze on tables
with bitmaps, the only way to get it to work (when it doesn't, but should) is with hints.

Tim

Maris Gabalins wrote in message <3477496D.128C290F_at_it.lv>...
>Hi
>
>Did you analyze the table before that ...?
>
>Sincerely
>Maris
>
>Ivars Grinbergs wrote:
>
>> Hi gurus,
>>
>> can anybody explain me when bitmap indexes are used? I have tried
>> examples from Server Tuning Guide, Bitmap Indexing section (SELECT *
>> FROM T WHERE C1 = 2 AND C2 <> 6 OR C3 BETWEEN 10 AND 20), but explain
>> plan told me, that full table scan will be used (of course, I have
>> created bitmap indexes on t).
>>
>> I.Grinbergs
>
>
>
Received on Sun Nov 23 1997 - 00:00:00 CST