> Oh, this is what I believe MySQL calls "loose index scans". I'm
Exactly :
http://dev.mysql.com/doc/refman/5.0/en/loose-index-scan.html
> actually looking into this as we speak,
Great ! Will it support the famous "top-n by category" ?
> but there seems to be a
> non-trivial amount of work to be done in order for this to work.
>
>
> Regards,
> Marko Tiikkaja