Re: Optimise SELECT ... LIMIT

2004-03-11 Thread David Bordas
> 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; > +---

Optimise SELECT ... LIMIT

2004-03-03 Thread David Bordas
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; +---+--+---