hi, I have some question about indexes more...
in this example we have table just like this: table_tbl tableid int [primary key] tablefield1 tablefield2 ... tablefieldx tablefieldsort1 int tablefieldsort2 varchar(32) there are lots of questions containing order by clause like: select t.* from table_tbl t where condition 1... condition 2... condition x... order by tablefieldsort1 desc tablefirldsort2 asc my question is: what indexes must be created to be used in order by clause? they must speed up search and order by ... with regards DeRyl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]