List:General Discussion« Previous MessageNext Message »
From:Mpu Gondrong Date:December 17 2002 4:12am
Subject:Re[4]: No descending index ?
View as plain text  
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]


Thread
No descending index ?Mpu Gondrong17 Dec
  • Re: No descending index ?Dan Goodes17 Dec
  • Re: No descending index ?Daniel Kasak17 Dec
  • Re: No descending index ?Jeremy Zawodny17 Dec
    • Re[2]: No descending index ?Mpu Gondrong17 Dec
  • Re: Re[2]: No descending index ?Jocelyn Fournier17 Dec
    • Re[4]: No descending index ?Mpu Gondrong17 Dec
Re: No descending index ?Daniel Kasak17 Dec