RE: Bitmap Index problem...

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Mon, 15 Jan 2001 15:46:02 -0000
Message-Id: <10742.126678@fatcity.com>

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-----

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Amar Kumar Padhi
Sent: Monday, January 15, 2001 08:35
To: Multiple recipients of list ORACLE-L Subject: Bitmap Index problem...

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). Received on Mon Jan 15 2001 - 09:46:02 CST