Great - I understand.
Thx.

Have a nice day Martijn :)

>
> Because of the expression, it cannot use the index for sorting.
>
> Given that your result returns just a few rows, it should sort those
> rows without the index, as hopping arround the index to find the
> row, put them in sorting order etc takes more time.
>
> 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
>