Help: Is it possible to use a bitmap index with a greater than

Home -> Community -> Usenet -> c.d.o.server -> Help: Is it possible to use a bitmap index with a greater than > in on the bitmapped column

From: Haild <haild_0234_at_hotmail.com>
Date: 30 Nov 2000 17:46:35 -0600
Message-ID: <3a26e5f5$0$690$45beb828@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 = ? Received on Thu Nov 30 2000 - 17:46:35 CST