Performance... what is faster using 1 or 2 keyword field in term search?

Elastic Stack Elasticsearch
1

Hi, I have ILM based indices that have multiple keyword fields.

I want query the data based on these terms. As it turns out, the two keyword fields have the following property...

Keyword2 is unique across the all Keyword1
Keyword1is NOT unique across all Keyword2

so if I am searching against Keyword2 I don't really need Keyword1 to get the data I want. However I wonder if using a bool AND filter with Keyword1 and Keyword2 is faster or slower than a query on just Keyword2?

Thoughts appreciated...

Thanks,
Karl

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.