Hey all, I have an index with a lot of documents with the term X and no documents with the term Y. If i query for X it take a few seconds and returns the results. If I query for Y it takes a millisecond and returns an empty set. If i query for Y AND X it takes a few seconds and returns an empty set.
I'm guessing that it evaluate both X and Y and only then tries to intersect them? Am i wrong? is there another way to run this query more efficiently? thanks for any input