-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
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
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;
Hi!
I have this table :
mysql describe proc;
+-+---+--+-+
-+---+
| Field | Type | Null | Key | Default
| Extra |
+-+---+--+-+
-+---+
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 |
-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