On Fri, Mar 14, 2008 at 12:28 AM, Ow Mun Heng <Ow.Mun.Heng@wdc.com> wrote:
> query is something like this
>
> Select *
> from v_test
> where acode Like 'PC%'
> and rev = '0Q'
> and hcm = '1'
> and mcm = 'K'
>
> where acode, rev, hcm, mcm are all indexes.
>
> Currently this query is only using the rev and mcm for the bitmapAND.
> it then does a bitmap heap scan using the acode and the hcm indexes.
>
> I would like to try to see if forcing the planner to favour heavier usage of the indexes would yield faster results.
>
> I've tried lowering
Would setting enable_bitmapscan=off do that? I'm not being sarcastic,
I really don't know.