mysql performance optimization -- add filter

SELECT id
FROM question
WHERE id <> 8668
AND deleted=0
AND status = 'resolved'
ORDER BY created_at DESC
limit 0,10;

43814 lines
0.26s


SELECT id
FROM question
WHERE id <> 8668
AND deleted=0
AND status = 'resolved'
AND created_at > '2010-01-18'
ORDER BY created_at DESC
limit 0,10;

40 lines
0.01s