What's your db_file_multiblock_read_count set to? How many rows are in the
table? Is the table analyzed? These factors will affect how optimizer
behaves.
I am using bit mapped indexes since Ver 7.3 with good results.
> -----Original Message-----
> From: Amar Kumar Padhi [SMTP:TS2017_at_emirates.com]
> Sent: Tuesday, January 16, 2001 2:05 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Bitmap Index problem...
>
> Sorry, didn't work with hint either.
> I tried with and without statistics also.
> Our system is rule based.
> Any other idea?
>
> Thanks,
> Amar Kumar Padhi
> Software Consultant
>
> -----Original Message-----
> Sent: Monday, January 15, 2001 7:46 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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..
Received on Tue Jan 16 2001 - 07:23:44 CST
