# Index.mapping.total\_fields.limit is important only for query operations?

**URL:** <https://discuss.elastic.co/t/index-mapping-total-fields-limit-is-important-only-for-query-operations/218217>\
**Category:** Elasticsearch\
**Created:** [February 6, 2020, 4:25pm UTC](https://discuss.elastic.co/t/index-mapping-total-fields-limit-is-important-only-for-query-operations/218217 "2020-02-06T16:25:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![111287](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/111287/32/62139_2.png) [@111287](https://discuss.elastic.co/u/111287)\
**Post date:** [February 6, 2020, 4:25pm UTC](https://discuss.elastic.co/t/index-mapping-total-fields-limit-is-important-only-for-query-operations/218217/1 "2020-02-06T16:25:51Z")

</div>

Hello,

On next page I fount interesting statement regarding mapping total fields limit settings:

> **[Mapping | Elasticsearch Guide \[8.11\] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping.html#mapping-limit-settings)**

> `index.mapping.total_fields.limit`  
> The maximum number of fields in an index. Field and object mappings, as well as field aliases count towards this limit. The default value is `1000` .  
> The limit is in place to prevent mappings and searches from becoming too large. Higher values can lead to performance degradations and memory issues, especially in clusters with a high load or few resources.  
> If you increase this setting, we recommend you also increase the [`indices.query.bool.max_clause_count`](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-settings.html) setting, which limits the maximum number of [boolean clauses](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-bool-query.html) in a query.

_I just want to clarify this:_  
_It's definitely not important for Lucene indexes, as each document field is the independent Lucene index._  
_I can assume that this settings makes sense only in case of performing query to search by all 1000 fields together. In this case I can understand the limit, I even think that it has to be even smaller. Even such queries is unbelievable for me =)_  
_Anyway, could you please, add additional clarification for that notice._  
**Actually, I tried add this by myself:**

> <https://github.com/elastic/elasticsearch/pull/51953>
>
> I just want to clarify this:
> It's definitely not important for Lucene indexes, …as each document field is the independent Lucene index.
> I can assume that this settings makes sense only in case of performing query to search by all 1000 fields together. In this case I can understand the limit, I even think that it has to be even smaller. Even such queries is unbelievable for me =)

**But my PR was closed, and I'm not suer, that I'm not right.**  
**The comments from PR:**

 ![Screen Shot 2020-02-06 at 10.32.53 AM](https://us1.discourse-cdn.com/elastic/original/3X/7/5/75f416f4ad6b46eadc97e57fde74f297a3026bfe.png)

 ![Screen Shot 2020-02-06 at 10.33.37 AM](https://us1.discourse-cdn.com/elastic/original/3X/e/9/e930cd914ddc32dc53fba693d0d8d2350d10cf32.png)

 ![Screen Shot 2020-02-06 at 10.34.07 AM](https://us1.discourse-cdn.com/elastic/original/3X/7/7/77c8da895e1adf0cf69c130773b906459d0e95cd.png)

---

<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:** [March 5, 2020, 4:25pm UTC](https://discuss.elastic.co/t/index-mapping-total-fields-limit-is-important-only-for-query-operations/218217/2 "2020-03-05T16:25:56Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.