This just describes how MySQL uses single index there are more complex rules of how indexes will be used if you look at multiple indexes usage with index merge Using Index to Sort Data Another great benefit of BTREE index is it allows to retrieve data in sorted form hence avoiding external sort process for executing of queries which require sorting.