Support for specifying ASC/DESC for each element in a multicolumn index

Description

This is a follow-up improvement request to – it's good to have multi-column indexes, but the current implementation is very limited, at least for sorting purposes.

Given columns A and B, it is quite likely that one needs to sort by A DESC, B ASC or vice versa. Current multi-column indexes will not be able to boost this sorting (at least, to my knowledge, in most database systems) and it is at least 50% of all the cases where we sort by several fields.

Thanks for your consideration.

Environment

None

Testing Notes

Add notes...

Status

Assignee

Unassigned

Reporter

Igor Sereda [ALM Works]

Labels

None

Add-on Type

None

Team

None

CC

None

Risk factor

None

QA Kickoff Status

None

QA Demo Status

None

Priority

Major
Configure