This very much sounds like databases do not, in fact, support indexing on more than one thing at once.
replyYes, you cannot be in one order and also a different order at the same time. You can make another index, but that's something else entirely.
reply