Purpose of ASC/DESC indexes

hi!

You query will most likely not use the index because you select *.

The following query will most likely use the index:


Code:
SELECT first_name
  FROM copy_emp
 ORDER BY first_name DESC;
However, it will also use the same query declared with DESC if you query with ASC:

Code:
SELECT first_name
  FROM copy_emp
...