Hacker News new | past | comments | ask | show | jobs | submit
This very much sounds like databases do not, in fact, support indexing on more than one thing at once.
Yes, 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.