just wondering if there's a special tweak i can do to force more usage
of indexes to do BITMAP ands?
I have a table like
A int
B int
C int
D int
E int
F int
g int
where A/B/C/D/E are indexes
There's ~20millions rows in the table.
Query are something like this.
select * from table
where A=X
and B = Y
and C = Z
and D = AA
and E = BB
the query plan will only pick 2 indexes to do the bitmap.
I'm not sure how to tweak the config for it to use more indexes.
Box is a celeron 1.7 w/ 768MB ram with shared buffers at 250MB and
effective cache size 350MB