# Performance: Adding multiple indexes in term query in a search request

**URL:** <https://discuss.elastic.co/t/performance-adding-multiple-indexes-in-term-query-in-a-search-request/372994>\
**Category:** Elasticsearch\
**Created:** [January 9, 2025, 11:47am UTC](https://discuss.elastic.co/t/performance-adding-multiple-indexes-in-term-query-in-a-search-request/372994 "2025-01-09T11:47:02Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ajayraghav](https://avatars.discourse-cdn.com/v4/letter/a/a9a28c/32.png) [@ajayraghav](https://discuss.elastic.co/u/ajayraghav)\
**Post date:** [January 9, 2025, 11:47am UTC](https://discuss.elastic.co/t/performance-adding-multiple-indexes-in-term-query-in-a-search-request/372994/1 "2025-01-09T11:47:02Z")

</div>

I intend to use query\_string and term queries (across multiple indexes) on \_search.  
My combined query is this,

"query": {  
"bool": {  
"must": [  
{  
"query\_string": {  
"fields": [  
"\*"  
],  
"query": "_tes_"  
}  
}  
],  
"should": [  
{  
"bool": {  
"must": [  
{  
"terms": {  
"\_index": ["people", "organization"]  
}  
}  
],  
"should": [  
{  
"terms": {  
"zoneId": [1, 51]  
}  
},  
{  
"term": {  
"ownerId": 1  
}  
}  
],  
"minimum\_should\_match": 1  
}  
},  
{  
"bool": {  
"must": [  
{  
"terms": {  
"\_index": ["event", "meeting"]  
}  
},  
{  
"term": {  
"ownerId": 1  
}  
}  
]  
}  
},  
{  
"bool": {  
"must": [  
{  
"term": {  
"\_index": "activity"  
}  
}  
]  
}  
},  
{  
"bool": {  
"must": [  
{  
"terms": {  
"\_index": ["note", "attachment"]  
}  
}  
],  
"should": [  
{  
"bool": {  
"must": [  
{  
"terms": {  
"source": ["event", "meeting"]  
}  
}  
],  
"should": [  
{  
"terms": {  
"territoryId": [1,51]  
}  
},  
{  
"term": {  
"ownerId": 1  
}  
}  
],  
"minimum\_should\_match": 1  
}  
},  
{  
"bool": {  
"must": [  
{  
"term": {  
"source": "activity"  
}  
},  
{  
"term": {  
"ownerId": 1  
}  
}  
]  
}  
}  
],  
"minimum\_should\_match": 1  
}  
}  
],  
"minimum\_should\_match": 1  
}  
}  
}

How would the performance be if I performed a query on 100k records? Or should I use \_msearch by breaking the query down based on index? If multiple users are sending requests how would the network overhead would be? Would there be latency? Thank you for any clarifications