Re: Bitmap index usage...

Hi,
Try analyze table t compute statistics.

                Peter.

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 Fri Nov 21 1997 - 00:00:00 CST