Hello,
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)