# DeleteByQuery Performance Question

**URL:** <https://discuss.elastic.co/t/deletebyquery-performance-question/360490>\
**Category:** Elasticsearch\
**Created:** [May 29, 2024, 3:52pm UTC](https://discuss.elastic.co/t/deletebyquery-performance-question/360490 "2024-05-29T15:52:30Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dhubau](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dhubau/32/134905_2.png) [@dhubau](https://discuss.elastic.co/u/dhubau)\
**Post date:** [May 29, 2024, 3:52pm UTC](https://discuss.elastic.co/t/deletebyquery-performance-question/360490/1 "2024-05-29T15:52:30Z")

</div>

Hello,

Wondering how effficient a typical DeleteByQuery request is on an index alias backed by multiple indices (let's say 1 hot index and 30 daily warm indices of 30M documents each).

Our actual query would only contain an ID term, so I'm guessing this should still be quite efficient to do?

How does DeleteByQuery efficiency drop when doing it on an index alias backed by Warm indices?