> 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.

Don't depend on indices for sorting, depend on indices for filtering.


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com