Re: Performance: BITMAP index vs. Non-Bitmap Index

antonberg1_at_gmx.de wrote:
> Hi,
>
> in the explain plan of an sql-statement I have the following part:
> BITMAP CONVERSION TO ROWIDS
> and then a Bitmap-Index is used.
>
> Now, I deleted the Bitmap-Option from this index and the sql-statements
> are performing much better. They only need 20% of the time, when using
> a Bitmaped index.
>
> What could be the reason for this? The conversion?
>
> Thanks for your help,
> Anton

I tried to find the Explain Plan in your post but apparently it is really really small. And the Oracle version?

Some here may be good at mental telepathy but I get headaches when I try to read my own mind ... much less someone else's.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)