[BanyanDB-Server] Optimizing the query with low cardinality

[hanahmily]

Search before asking

• I had searched in the issues and found no similar feature requirement.

Description

We have observed performance bottlenecks in BanyanDB when executing queries involving series-indexed tags with low cardinality. These queries are critical, and their current inefficiency could affect overall system performance and user experience.

I will move these tags' values into the series index from the data files to reduce the impact of low cardinality.

Use case

No response

Related issues

No response

Are you willing to submit a pull request to implement this on your own?

• Yes I am willing to submit a pull request on my own!

Code of Conduct

• I agree to follow this project's Code of Conduct