Re: Can Explain detect bitmap index?

On Mon, 7 Dec 1998 12:16:35 +0100, pcucciolo_at_hotmail.com wrote (in message <74gdei$92k$1_at_nnrp1.dejanews.com>):
>
> I have made a test whit explain on a table indexed by bitmap index. Explain
> says: full table scan. Explain in another test whit a classic index on the
> same table and same column whit the same query say: scan by row_id. Where
> is the true?
>
> Oracle Ver. 8.0.4 on Windows NT.
>
> Thank you.
>
> P.S. Excuse me for my English.
>
> -----------== Posted via Deja News, The Discussion Network ==----------

> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Does your instance you tested in with de BITMAP run using cosbased optimizer ? In that case you will have to create histograms for that table in order to use the BITMAP index. I assume the instance running the classic index was rulebased.

-- Received on Mon Dec 07 1998 - 14:41:53 CST