Index oder


How can I define the order to use in an index ?

for instance, in MSSQL, I can create an  index as follow:

"CREAT INDEX IX_NAME on [dbo].[myDB].[MyTable] (Name DESC)"

And that will create the index in reverse order for the "Name" column.

It's important for any database that can use a specific index for specifying the sort order of a result set (I'm writing a paradox driver and that ability is crucial for performances)

That is currently not possible, you can only define the columns of the index, not their order.