# Index Sort settings both asc and desc?

**URL:** <https://discuss.elastic.co/t/index-sort-settings-both-asc-and-desc/128680>\
**Category:** Elasticsearch\
**Created:** [April 19, 2018, 10:56am UTC](https://discuss.elastic.co/t/index-sort-settings-both-asc-and-desc/128680 "2018-04-19T10:56:39Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![grillorafael](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/grillorafael/32/30172_2.png) [@grillorafael](https://discuss.elastic.co/u/grillorafael)\
**Post date:** [April 19, 2018, 10:56am UTC](https://discuss.elastic.co/t/index-sort-settings-both-asc-and-desc/128680/1 "2018-04-19T10:56:40Z")

</div>

Hi All,

we are trying to upgrade our ElasticSearch cluster from 5 to 6 and we are trying to use index sorting features.

We have a fat index that is always queried sorted by a given field but it could be both asc or desc.

Today if I specify index sort "asc", I get faster read in asc but a lot slower in desc.

Is there a way to deal with that? Or just by removing index sorting?

---

<div class="post-metadata">

**Author:** ![thiago](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thiago/32/32096_2.png) [@thiago](https://discuss.elastic.co/u/thiago)\
**Post date:** [April 24, 2018, 4:53am UTC](https://discuss.elastic.co/t/index-sort-settings-both-asc-and-desc/128680/2 "2018-04-24T04:53:46Z")

</div>

You only get to select one field and one sort order for index time sorting. If you need multiple fields and/or multiple sort orders then you need more than one index (i.e. one index per sort order).

---

<div class="post-metadata">

**Author:** ![ddorian43](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ddorian43/32/36093_2.png) [@ddorian43](https://discuss.elastic.co/u/ddorian43)\
**Post date:** [April 24, 2018, 10:14pm UTC](https://discuss.elastic.co/t/index-sort-settings-both-asc-and-desc/128680/3 "2018-04-24T22:14:14Z")

</div>

You saying if you remove index\_sort:asc, when you sort:desc, it's faster than before ?

I assume you sort the index by the most often one and keep it slow on the other direction ?

---

<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:** [May 22, 2018, 10:14pm UTC](https://discuss.elastic.co/t/index-sort-settings-both-asc-and-desc/128680/4 "2018-05-22T22:14:18Z")

</div>

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