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] Why that, usertime systemtime are data

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. Well, normally

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;

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

2001-03-24 Thread Nemholt, Jesper Frank
Hi! I have this table : mysql describe proc; +-+---+--+-+ -+---+ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+ -+---+

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 |

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, you should run an analyize on your indexes