Corin Langosch <[EMAIL PROTECTED]> wrote:
>
> update of my last email sent.
>
> when i use the
> sql: 'EXPLAIN SELECT datum FROM actions ORDER BY datum'
>
> the key gets used:
> table type possible_keys key key_len ref rows Extra
> actions index NULL datum 8 NULL 75859 Using index
>
> ho
Corin Langosch wrote:
Hello,
thanks for your fast reply. even when i use
EXPLAIN SELECT * FROM `actions` ORDER BY datum LIMIT 10
the key isn't used. the query takes about 2s :-(
What does it show if you do a
show indexes from actions
---
If you are sure the optimizer is w
Hi Corin,
As I said - I don't have the slightest idea about the MySQL optimizer,
but I'm trying to learn.
> thanks for your fast reply. even when i use
> EXPLAIN SELECT * FROM `actions` ORDER BY datum LIMIT 10
> the key isn't used. the query takes about 2s :-(
What if you do:
SELECT ... WHERE D
Hello,
thanks for your fast reply. even when i use
EXPLAIN SELECT * FROM `actions` ORDER BY datum LIMIT 10
the key isn't used. the query takes about 2s :-(
Corin
Tuesday, December 9, 2003, 10:19:16 AM, you wrote:
MT> Hi,
MT> I'm not saying I fully understand the MySQL optimizer, as
MT> I never
: 'EXPLAIN SELECT datum,id FROM actions ORDER BY datum'
the key isn't used anymore :-(.
might this be bug of mysql?
Corin
---
This is a forwarded message
From: Corin Langosch <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Date: Tuesday, December 9, 2003, 10:11:03 AM
Hi,
I'm not saying I fully understand the MySQL optimizer, as
I never had to deal with it before... but:
Why should it use an index if the statement is returning ALL
rows? It might be faster to read them into memory ( 75853
isn't really much ) and sort them there instead of moving the
diskhead ba
Hello,
i'm having a problem with mysql. when i put an index on a
datetime column, it's never used.
for example the
sql: 'EXPLAIN SELECT * FROM actions ORDER BY datum'
shows:
table type possible_keys key key_len ref rows Extra
actions ALL NULL NULL NULL NULL 75853 Using filesort
even if i
