Hi! I'm thinking of ways to improve my search performance, and I've been considering index sorting:
We won't be indexing much, so I'm not really concerned about the added write cost. However, I'm wondering if any of you have thoughts on whether or not index sorting would be appropriate. For context, we will be searching on first name, last name, and DOB (stored as an 8char string). Do these fields have low enough cardinality for me to see any improvements? Additionally, all of our searches will be fuzzy. Should I still expect any improvements?
I'll be testing this regardless, I just wanted to send out some feelers to see if any of you have similar experiences or helpful insights.