Ten filter fields. 1,023 possible combinations.
Based on KapoorLabs' engineering article, October 2026
Every field you add to a filter panel doubles the combinations users can pick. Exact-key lookups need one key per combination. Composite indexes cut that down, but each one only serves its leading columns.
Kiara keeps one index per field and joins them at query time. Records are stored as paths in a tree, nodes are numbered, and conditions combine with integer range checks.