Selasa, 17/12/2002 9:14:39, Jocelyn menulis:

>> 30%, so no index used
JF> So the result of your explain seems normal for me.

Sooo...,  back  to  my  first thread, could I use index for such query
(datec  <=  '...') ? Query resulting < 30% is very seldom (so index is
mostly  never  used),  and  very  weird  if  ascending  index used for
descending  query.  I'm not talking about returning correct result set
(either order by desc, limit, etc), but avoid table scan.

This  is  my  first  serious  mysql  application, as usually i'm using
Interbase where has descending index feature. Well..., any hope ? Btw,
thanks for all replies.

Tertanda,
Oguds [36856104]



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to