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.