# Best practice to decide number of index

**URL:** https://discuss.elastic.co/t/best-practice-to-decide-number-of-index/49373
**Category:** Elasticsearch
**Created:** [May 6, 2016, 6:08am UTC](https://discuss.elastic.co/t/best-practice-to-decide-number-of-index/49373 "2016-05-06T06:08:50Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Pradeep\_Gowda](https://avatars.discourse-cdn.com/v4/letter/p/ebca7d/32.png) [@Pradeep\_Gowda](https://discuss.elastic.co/u/Pradeep_Gowda)
#### Post date: [May 6, 2016, 6:08am UTC](https://discuss.elastic.co/t/best-practice-to-decide-number-of-index/49373/1 "2016-05-06T06:08:51Z")

</div>

Hey All,  
What is the best practice to create a number of indexes if I have around 500 to 700 millions of record per day? One index per day or multiple indexes per day (Let's say one per 6 hours) where there is an aggregation need to be done every minute on this data.

---

<div class="post-metadata">

### Author: ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [May 6, 2016, 6:23am UTC](https://discuss.elastic.co/t/best-practice-to-decide-number-of-index/49373/2 "2016-05-06T06:23:34Z")

</div>

Query performance tend to vary with shard size. I would therefore recommend running your aggregations against a single shard to see what a good size is for your use case. In order to keep your shard size below this level, you don't necessarily need multiple indices per day as you can simply increase the number of shards per index to get to the right size. It may be worthwhile looking at [this video from Elastic{ON} 2016](https://www.elastic.co/elasticon/conf/2016/sf/quantitative-cluster-sizing) which discusses benchmarking and cluster sizing.

---

<div class="post-metadata">

### Author: ![Pradeep\_Gowda](https://avatars.discourse-cdn.com/v4/letter/p/ebca7d/32.png) [@Pradeep\_Gowda](https://discuss.elastic.co/u/Pradeep_Gowda)
#### Post date: [May 6, 2016, 6:28am UTC](https://discuss.elastic.co/t/best-practice-to-decide-number-of-index/49373/3 "2016-05-06T06:28:51Z")

</div>

Thank you very much!

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 5, 2017, 10:53pm UTC](https://discuss.elastic.co/t/best-practice-to-decide-number-of-index/49373/4 "2017-07-05T22:53:25Z")

</div>


