Hi, I am running filter query(range query) on date fields(high cardinality) and the performance is really bad ...it takes about 2-5 seconds for it to come back with response. I am rebuilding the index to have docvalues & tdates instead of "date" field. But not sure if that will alleviate the problem because of high cardinality.
Can I store the date as YYYYMMDD and run range queries on them instead of date fields? Is that a good option? -- Thanks Jay