| Subject | Re: How to mix ascending and descending fields in one index |
|---|---|
| Author | kokok_kokok |
| Post date | 2009-10-07T13:38:47Z |
I want to improve the performance of
select * from foo order by a asc, b desc
If I create 2 indexs, the plan is "natural" and the indexs are not used.
select * from foo order by a asc, b desc
If I create 2 indexs, the plan is "natural" and the indexs are not used.