MySQL query performance of Date sorted data
Your query is presumably something like:

select a.*
from activities a
where user_is = 'abc' and time &gt; somedate


or

where user_is = 'abc' and time &gt; somedate and type = xyz


The best index for the first query is activities(user_is, time) and for the second activities(user_id, type, time).