We have about 40 different indices being produced everyday. We currently have an alias setup for to point to the current business day index, and every night when the day rolls over, we create a new index and recreate the alias.
Ideally we would like to make the previous day's index read-only and move it to SAN. We would still be able to access it to run queries etc. I don't think the snapshot feature will allow us to query the index without restoring it.
Any thoughts/suggestions and best practises for what I am trying to achieve?