On Sun, 8 Sep 2002, Jan Ploski wrote:
> I am in particular wondering, why an index on message(sectionID, dateSent)
> does not make these queries comparably fast:
>
> select msgnum from message where
> sectionID = ? and
> dateSent > ?
> order by dateSent
> limit 1;
I don't think that'll use an index on (sectionID, dateSent) for the sort
step. I think an index on (dateSent,sectionID) might be, however.