Re: Bitmap index usage...

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 Sat Nov 22 1997 - 00:00:00 CST