I have 200m documents where half are marked (with a field) src = 1 and the other src = 2.
When searching, on multiple fields (usually 6-8), the search time differs dramatically if the src is included.
I realize that all the other fields query text are relatively rare, versus the src which is 100m no matter which one is picked. If I leave src out of the query, search time is 2.5x faster. (650ms down to about 260ms)
I've tried setting it up as a must, as a filtered query and even in the should query but in all cases the search time is impacted similarly.
Is there a way to enforce the src in some way that doesn't incur such a high penalty?