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
On Fri, Mar 14, 2008 at 12:28 AM, Ow Mun Heng [EMAIL PROTECTED] 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.
am Fri, dem 14.03.2008, um 14:28:15 +0800 mailte Ow Mun Heng folgendes:
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
On Fri, 2008-03-14 at 00:50 -0600, Scott Marlowe wrote:
On Fri, Mar 14, 2008 at 12:28 AM, Ow Mun Heng [EMAIL PROTECTED] wrote:
query is something like this
Select *
from v_test
where acode Like 'PC%'
and rev = '0Q'
and hcm = '1'
and
On Fri, 2008-03-14 at 07:53 +0100, A. Kretschmer wrote:
am Fri, dem 14.03.2008, um 14:28:15 +0800 mailte Ow Mun Heng folgendes:
query is something like this
Select *
from v_test
where acode Like 'PC%'
and rev = '0Q'
and hcm = '1'
and mcm = 'K'
am Fri, dem 14.03.2008, um 15:06:56 +0800 mailte Ow Mun Heng folgendes:
On Fri, 2008-03-14 at 07:53 +0100, A. Kretschmer wrote:
am Fri, dem 14.03.2008, um 14:28:15 +0800 mailte Ow Mun Heng folgendes:
query is something like this
Select *
from v_test
where acode Like
On Fri, 2008-03-14 at 08:26 +0100, A. Kretschmer wrote:
am Fri, dem 14.03.2008, um 15:06:56 +0800 mailte Ow Mun Heng folgendes:
On Fri, 2008-03-14 at 07:53 +0100, A. Kretschmer wrote:
am Fri, dem 14.03.2008, um 14:28:15 +0800 mailte Ow Mun Heng folgendes:
query is something like