explain select * from t1234 where campaignid='Finland' AND adgroupid IN ('Lahti','Imatra') OR campaignid='Russia' AND adgroupid IN ('Petersburg', 'Moscow') OR campaignid='Sweden' AND adgroupid IN ('Stockholm', 'Uppsala') OR campaignid='Germany' AND adgroupid IN ('Berlin', 'Frankfurt') OR campaignid='Belgium' AND adgroupid IN ('Brussels', 'Gent') OR campaignid='Portugal' AND adgroupid IN ('Lisbon', 'Porto') AAA "tree": { "ranges": { B-F-G-P-R-S }, "merges": [ { "index_merge": { "tree": { "ranges": { B-F-G-R-S }, "merges": [ { "index_merge": { "tree": { "ranges": { F-G-R-S }, "merges": [ { "index_merge": { "tree": { "ranges": { F-R-S }, "merges": [ { "index_merge": { "tree": { "ranges": { F-R }, "index_merge": { F or R } }, "tree": { S } } }, { "index_merge": { "tree": { F }, "tree": { R }, "tree": { S } } }, { "index_merge": { "tree": { F R }, "tree": { R S } } } ] }, "tree": { "ranges": { G } } } }, { "index_merge": { "tree": { F R } , "tree": { S } , "tree": { G } } }, { "index_merge": { "tree": { F G R } , "tree": { G S } } } ] }, "tree": { B } } }, { "index_merge": { "tree": {F R S}, "tree": { G } , "tree": { B } } }, { "index_merge": { "tree": { B F R S } , "tree": { B G } } } ] }, "tree": { P } } }, { "index_merge": { "tree": { F G R S } , "tree": { B }, "tree": { P } } }, { "index_merge": { "tree": { F G P R S } , "tree": { B P } } } ] }