Hi, I have a 125 million doc index1. I identified 25 values for fieldA in the index. Each value can appear multiple times (1).
There is another fieldB in the same index. I identified 6 values for this fieldB. I want only those records in (1) which contain any of these values in fieldB. Query:- q=field1:(value1 OR value2 OR value3 OR .... value25) AND fieldB:(value1 OR ... value6) Again, I have fiedB values in another index1 of mine which has 3000 docs. So I can do:- q=field1:(value1 OR value2 OR value3 OR .... value25)&fq=join of index1 with index2 using fieldB as the join key. Which query is more efficient. Or is there a third better way? Thanks! Mark
