Bitmap index usage...

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