RE: Bitmap Index problem...

Amar,

If you want to use bitmap, you must use CBO.

Regards.

> -----Mensaje original-----
> De: Mark Leith [SMTP:mark_at_cool-tools.co.uk]
> Enviado el: lunes 15 de enero de 2001 16:46
> Para: Multiple recipients of list ORACLE-L
> Asunto: RE: Bitmap Index problem...
>
> Hi Amar,
>
> How about using a hint to force the use of the index? You could do
> something
> like:
>
> select /*+ INDEX(am33_col1) */ * from am33
> where blah blah....
>
> This then forces this index to be used..
>
> HTH
>
> Mark
>
> -----Original Message-----
> Padhi
> Sent: Monday, January 15, 2001 08:35
> To: Multiple recipients of list ORACLE-L
>
>
> Hi,
> I have created a bitmap index on a table. The same query behaves
> differently
> under various optimisation modes, on 8.1.7 db
>
> -desc am33
> Name Null? Type
> ------------------------------- -------- ----
> COL1 NUMBER
> COL2 VARCHAR2(10)
>
> -create bitmap index am33_col1 on am33(col1);
> Index created.
> -select * from am33
> 2 where col1 = 1;
>
> COL1 COL2
> __________ __________
> 1 checking
>
> I changed the optimisation mode and got the following results:
> RULE- full scan
> CHOOSE - full scan
> FIRST_ROWS - using bitmap index.
> ALL_ROWS - full scan
>
> I want to use the bitmap index for non-cost based db's. Any idea how to go
> about it?
> Note: compatible set to 8.1.7
>
> Thanks,
> Amar Kumar Padhi
> Software consultant
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Amar Kumar Padhi
> INET: TS2017_at_emirates.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mark Leith
> INET: mark_at_cool-tools.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Mon Jan 15 2001 - 11:50:45 CST