8 ms·A composite index will work wonders for this situation. EXPLAIN is your friend.by rbranson 15y agoA composite index will work wonders for this situation. EXPLAIN is your friend.