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