today, i checked my slow query log and saw lots of slow queries.
it's looks like:
SELECT uid,uname FROM usertbl WHERE country='us' ORDER BY lastlogin DESC LIMIT 0,20;
i INDEXED country field.
so should i index lastlogin field?
and one more question, should i use DISTINCT or GROUP BY to filter duplicate records?