Hello, I have been attempting to uncover a fast method for retrieving unique items from every column in a table. The table has approximately 60 thousand rows. Each row has an index associated with it, and running 'explain select distinct class from dlist' shows that it is using the index.
However, since there are 24 columns, running that select query for each column takes about 4 long seconds on a P4 2.4 Ghz. I've been unable to find any suitable leads through google or the list archives. Any cluebats will be gleefully appreciated. Thanks for reading! -- Willie Gnarlson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]