Server is 3.23.40, for sun-solaris2.7 (sparc) Is it possible to define an element of a key as being in descending order? The info in the manual regarding the "Collation" index attribute says that an index element can be "A" for ascending or NULL for not sorted (why would you have an index element not sorted?). Specifically we am having trouble with a query that has an ORDER BY clause containing the DESC keyword. This query takes a long time. The same query without the DESC is much faster. An EXPLAIN of the query containing the DESC has "Where used ;Using filesort" in the Extras column, the same query without the DESC has only "Where Used". All index elements in this case are in ascending order. The manual also says that queries using filesort require a second pass and therefore are going to be significantly slower. Any response would be appreciated. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php