what is a purpose of index with order if the query has order 1 column, do we need to use order in index

For a query that sorts by only one column, you do not need to explicitly specify a sort direction (like DESC) when creating the index, because databases can read a single-column index both forward and...