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