Thank you for the suggestion. I did think about adding some "WHERE" clause. I just have to find what "where" select.
>The index won't be used for the ORDER BY, but to resolve a JOIN or WHERE clause. ORDER BY is applied to the result set after the data has been selected. You can speed up the query by applying a WHERE condition so that the entire table isn't ordered or by using fewer fields instead of all of them.
>
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham