My Elasticsearch index is time-based: one index per month at this scale:
- number of Documents: 100M
- Size: 125 GB
The index was created with 12 shards + 2 replicas.
Since the date range for most of my user's search requests are only across 2-3 days, does it make sense to create one index per day and use alias to join them? Will this improve query performance?