Re: Another index question

2001-05-25 Thread Marc Delisle
Did you try EXPLAIN before SELECT? http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#EXPLAIN Mike Baranski a écrit : > > For the following select: > > SELECT DISTINCT badge_history.xact_date AS xact_date, (...) -- Marc Delisle Service de l'

Another index question

2001-05-25 Thread Mike Baranski
For the following select: SELECT DISTINCT badge_history.xact_date AS xact_date, badge_history.xact_time AS xact_time, badge_history.last_name AS last_name, badge_history.bid AS bid, badgests.cond_desc AS status, department.description AS department, badge_history.reader_desc AS reader_desc, area.