Re: How to index this properly (to make it go faster) ?

2001-03-27 Thread Benjamin Pflugmann
Hi. On Tue, Mar 27, 2001 at 08:22:39PM +0100, [EMAIL PROTECTED] wrote: > > -Original Message- > > From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] [...] > > > Aha, I'll have to test more with the individual order of > > combined indexes to > > > see what I can get from it. > > > > We

RE: How to index this properly (to make it go faster) ?

2001-03-27 Thread Nemholt, Jesper Frank
> -Original Message- > From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] > Sent: martes, 27 de marzo de 2001 10:00 > To: Nemholt, Jesper Frank > Cc: '[EMAIL PROTECTED]' > Subject: Re: How to index this properly (to make it go faster) ? > [clip] > >

Re: How to index this properly (to make it go faster) ?

2001-03-26 Thread Benjamin Pflugmann
Hello. On Sun, Mar 25, 2001 at 01:17:12AM -, [EMAIL PROTECTED] wrote: > > -Original Message- > > From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] [...] > Here's from the real one : > > mysql> show index from proc; > +---++-+--+-+

RE: How to index this properly (to make it go faster) ?

2001-03-24 Thread Nemholt, Jesper Frank
> -Original Message- > From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] > Sent: sabado, 24 de marzo de 2001 23:31 > To: Nemholt, Jesper Frank > Cc: '[EMAIL PROTECTED]' > Subject: Re: How to index this properly (to make it go faster) ? > > First,

Re: How to index this properly (to make it go faster) ?

2001-03-24 Thread Benjamin Pflugmann
Hi. On Sat, Mar 24, 2001 at 10:53:19AM -, [EMAIL PROTECTED] wrote: > Hi! > > I have this table : > > mysql> describe proc; > +-+---+--+-+ > -+---+ > | Field | Type | Null | Key | Default > | Extra