Hi all, I have an index with 40 million small records with about 10 fields each. As my index size grows, I've noticed that queries involving the date field ( range queries, order by, etc) are taking a disproportionately long time. Could this perhaps be because a date field has so many possible unique values? I don't know how to find out exactly, but I'd guess there are at least a few million unique dates in the index. Would increasing the granularity of the date field so that there are less unique values likely increase search speed? Any other suggestions?
Thanks, - Galen
