Re: Help: Is it possible to use a bitmap index with a greater than > in on the bitmapped column

It is possible - but the statistics
may be against you. What fraction
of the table does oracle think it will
get using the index ?

You might try just the INDEX() hint
rather than INDEX_COMBINE()

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
Book bound date: 8th Dec 2000
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Haild wrote in message <3a26e5f5$0$690$45beb828_at_newscene.com>...


>have a query

>

>

>select /* index_combine(ts_b052r_billing_determinants,BITMAP_CUST_PRORATE)

 */


>* from ts_b052r_billing_determinants ts

>where ts.CUST_PRORATE_FAC = 2

>

>it uses the bittmap

>

>

>this query

>

>

>select /* index_combine(ts_b052r_billing_determinants,BITMAP_CUST_PRORATE)

 */


>* from ts_b052r_billing_determinants ts

>where ts.CUST_PRORATE_FAC > 2

>

>will not use the bitmap no matter what we do.  Is it becuase a bitmap can

 not


>be used with a > or < just with an = ?