Hi, I have a problem with constructing efficient indexing for my query. It looks something like this:
filter A, B, c, d + sort E, A (capital letters means obligatory fields in query, small letters - optional, but it is not important for this topic, as I can just use more than one index). What index should I build to efficiently query?
What did you tried?
How did it failed? Sharing you explain plan may us.
Knowing the above would save us a lot of time by not investigating solutions you already know are not working.
The best way to help us help you is to create playground with sample documents and typical queries.
Otherwise, with the limited information you shared, the best we can offer is that you should follow the ESR rule.
@Szymon_Lenart, have you made any progress on this? A follow-up would be appreciated.
Thanks