Re: [GENERAL] forcing use of more indexes (bitmap AND)

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 someth

Re: [GENERAL] forcing use of more indexes (bitmap AND)

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 > > > w

Re: [GENERAL] forcing use of more indexes (bitmap 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

Re: [GENERAL] forcing use of more indexes (bitmap AND)

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 = '

Re: [GENERAL] forcing use of more indexes (bitmap AND)

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. > > Cu

Re: [GENERAL] forcing use of more indexes (bitmap AND)

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 indexe