Table employee: employeeNumber : int (primary key) age : int salary : float
Would an index improve performance for these queries? SELECT * FROM USERS ORDER BY age DESC LIMIT 100,200 (index on age) SELECT * FROM USERS ORDER BY salary DESC LIMIT 200,300 (index on salary) Is it OK if the index has duplicate keys (people with same age or salaries?) Thanks! __________________________________ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online. http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]