> Hi list,
>
> I'm trying to optimise a SELECT ... LIMIT query, perhaps i miss something
> important and so, i'm asking your help :)
>
> I'm using MySQL 4.0.15 under Linux.
>
> Here's a test query :
> mysql> explain SELECT * FROM F4000 WHERE ReplyTo=8711465 ORDER BY Numero
> LIMIT 234599,20;
>
+---
Hi list,
I'm trying to optimise a SELECT ... LIMIT query, perhaps i miss something
important and so, i'm asking your help :)
I'm using MySQL 4.0.15 under Linux.
Here's a test query :
mysql> explain SELECT * FROM F4000 WHERE ReplyTo=8711465 ORDER BY Numero
LIMIT 234599,20;
+---+--+---