Re: Using index with order desc

On 16 Jul 2002 16:35:18 -0400, Dave Smith <dave.smith@candata.com>
wrote:
>CREATE INDEX transfer_5 on transfer(company_id,module);
>
>explain select * from transfer where company_id=1012 order by
>company_id,module desc;

Dave,
    ...
    ORDER BY company_id DESC, module DESC
                            ^^^^

*might* help.

Servus
 Manfred