Hi,

we have a large table that contains a bitmask field:

CREATE TABLE A (
ID NUMBER(15),
......
MASK NUMBER(19)
)

The application then performs a query that includes BITAND(MASK, ?) > 0
condition.

Is there any way to use an index for this condition. I was thinking
about bitmap indexes for this but could not figure out how to use them
here.

Can anyone help?

Thank you,
Alex Kuntz.