Subject RE: [firebird-support] Creating a compound index
Author Alan McDonald
> I am curious if I can create a compound index with one field
> ascending and the other descenging. With the syntax to create an
> index, "Create Index" or Create descending index", it does not seem
> possible.
> If not what is the best way to create an index for something like this
> "unit_sort, effective_date desc, iteration_number desc"
> Above is one of the default sorts in one of the application's query.

nake 3 separate indexes as they appear here