Speed up SELECT DISTINCT

[Jim McAtee]

I have a web application using MySQL 3.2x server.  In the application 
theres an HTML form used for searching an ISAM table of about 500k 
records.  To populate select (drop down) fields in the form I do a couple 
of SELECT DISTINCT queries against this table.

What's the best indexing strategy to speed up these queries?  I've added 
indexes for both of the fields on which I do a SELECT DISTINCT.  It seems 
to have helped a little, but the queries are still fairly slow.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]