Christopher Jones wrote: > I have a relatively simple table with approximately 100 million rows > of data, and query times suck. I'd be interested to know whether > anyone thinks this is good, acceptable/normal, or bad; You didn't mention what indexes you have. If you don't have indexes on char and location, then make it so you do.