Re: Determining which index to create

On Wed, Nov 21, 2001 at 12:23:07PM +0100, Eric Cholet wrote:
> I would like to optimize the following query:
>
> => select * from dico_frs where motid=4742 order by date desc limit 10;
>
> But it's still quite slow. I'm thinking an index on (motid, date desc)
> would be best
> but that doesn't seem to be possible. How can I optimize this query?

Indexes (at least btree ones) can be scanned in either forward or backward
directions. So an index on (motid,date) should be fine.
--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/
> Magnetism, electricity and motion are like a three-for-two special offer:
> if you have two of them, the third one comes free.