# Statistical facet performance

**URL:** <https://discuss.elastic.co/t/statistical-facet-performance/11029>\
**Category:** Elasticsearch\
**Created:** [March 6, 2013, 4:44am UTC](https://discuss.elastic.co/t/statistical-facet-performance/11029 "2013-03-06T04:44:21Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![roytmana](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/roytmana/32/44855_2.png) [@roytmana](https://discuss.elastic.co/u/roytmana)\
**Post date:** [March 6, 2013, 4:44am UTC](https://discuss.elastic.co/t/statistical-facet-performance/11029/1 "2013-03-06T04:44:21Z")

</div>

Will indexing value field of statistical and terms\_stats facets as stored improve perf ormance?

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![Clinton\_Gormley](https://avatars.discourse-cdn.com/v4/letter/c/50afbb/32.png) [@Clinton\_Gormley](https://discuss.elastic.co/u/Clinton_Gormley)\
**Post date:** [March 6, 2013, 6:48pm UTC](https://discuss.elastic.co/t/statistical-facet-performance/11029/2 "2013-03-06T18:48:48Z")

</div>

No

clint

On Wed, Mar 6, 2013 at 5:44 AM, AlexR [roytmana@gmail.com](mailto:roytmana@gmail.com) wrote:

> Will indexing value field of statistical and terms\_stats facets as stored  
> improve perf ormance?
> 
> --  
> You received this message because you are subscribed to the Google Groups  
> "elasticsearch" group.  
> To unsubscribe from this group and stop receiving emails from it, send an  
> email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![roytmana](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/roytmana/32/44855_2.png) [@roytmana](https://discuss.elastic.co/u/roytmana)\
**Post date:** [March 6, 2013, 7:29pm UTC](https://discuss.elastic.co/t/statistical-facet-performance/11029/3 "2013-03-06T19:29:50Z")

</div>

Thanks Clint!

So when terms\_stats facet totals this field it will not try to load source it will use indexed values if it is indexed?

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![Ivan](https://avatars.discourse-cdn.com/v4/letter/i/df788c/32.png) [@Ivan](https://discuss.elastic.co/u/Ivan)\
**Post date:** [March 6, 2013, 9:39pm UTC](https://discuss.elastic.co/t/statistical-facet-performance/11029/4 "2013-03-06T21:39:29Z")

</div>

Correct, facets will use the field data cache for the values. The values  
are cached from the indexed Lucene fields.

If source was used, then the value will need to be analyzed, which would be  
more inefficient.

--  
Ivan

On Wed, Mar 6, 2013 at 11:29 AM, AlexR [roytmana@gmail.com](mailto:roytmana@gmail.com) wrote:

> Thanks Clint!
> 
> So when terms\_stats facet totals this field it will not try to load source  
> it will use indexed values if it is indexed?
> 
> --  
> You received this message because you are subscribed to the Google Groups  
> "elasticsearch" group.  
> To unsubscribe from this group and stop receiving emails from it, send an  
> email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![roytmana](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/roytmana/32/44855_2.png) [@roytmana](https://discuss.elastic.co/u/roytmana)\
**Post date:** [March 6, 2013, 9:52pm UTC](https://discuss.elastic.co/t/statistical-facet-performance/11029/5 "2013-03-06T21:52:15Z")

</div>

Thanks Ivan, Clint!

On Wed, Mar 6, 2013 at 4:39 PM, Ivan Brusic [ivan@brusic.com](mailto:ivan@brusic.com) wrote:

> Correct, facets will use the field data cache for the values. The values  
> are cached from the indexed Lucene fields.
> 
> If source was used, then the value will need to be analyzed, which would  
> be more inefficient.
> 
> --  
> Ivan
> 
> On Wed, Mar 6, 2013 at 11:29 AM, AlexR [roytmana@gmail.com](mailto:roytmana@gmail.com) wrote:
> 
> > Thanks Clint!
> > 
> > So when terms\_stats facet totals this field it will not try to load  
> > source it will use indexed values if it is indexed?
> > 
> > --
> > 
> > You received this message because you are subscribed to the Google Groups  
> > "elasticsearch" group.  
> > To unsubscribe from this group and stop receiving emails from it, send an  
> > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).
> > 
> > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).
> 
> --  
> You received this message because you are subscribed to a topic in the  
> Google Groups "elasticsearch" group.  
> To unsubscribe from this topic, visit  
> [https://groups.google.com/d/topic/elasticsearch/J-le4rWKs4Q/unsubscribe?hl=en-US](https://groups.google.com/d/topic/elasticsearch/J-le4rWKs4Q/unsubscribe?hl=en-US)  
> .  
> To unsubscribe from this group and all its topics, send an email to  
> [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<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 6, 2017, 2:47am UTC](https://discuss.elastic.co/t/statistical-facet-performance/11029/6 "2017-07-06T02:47:57Z")

</div>

Closed on July 6, 2017, 2:47am UTC


