My db has more than 35 million records. If I issue a count(column name), group by query, it take very very very long time to run. What's the fast way to run this count query. Please advise. Thank you.

You could break down the query into multiple ones to get the same basic info.

Or just make sure it's indexed properly.

____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)