Hello,
I am running 7.3.2 RPMs on RH9, on a celeron 1.7 w/ 1gig ram.
I have a table that has 6.9 million rows, 2 columns, and an index on
each column. When I run:
SELECT DISTINCT column1 FROM table
It is very, very slow (10-15 min to complete). An EXPLAIN shows no
indexes are being used.
Is there any way to speed this up, or is that DISTINCT going to keep
hounding me?
I checked the mailing list, and didn't see anything like this.
Any tips or hints would be greatly appreciated. Thanks for your help!
Seth