Is there any limitation on maximum number of bool clauses in a query (AND/OR). I believe it is 1024 and can be set in cluster configuration? But can someone clarify!
Also, what is the performance impact of a query that has so many clauses >=1024. I have few of them and trying to find how do I decide on cluster scale/settings early. The queries do query more than 40 indexes that keeps data for around 1 year. The volume I'm looking is close to 3-4 Billions. It is a aggregate query viz. Filter + Search.
My current plan is to do some delay loading viz. Query indexes from latest to old and slowly change graphs...regardless, my concern is 1024+ clauses in querystring LUCENE query..