[Labs-l] query optimization

[Yetkin Sakal]

user_daily_contribs having been dropped, I am facing serious problems about a query. How to optimize this?
SELECT
    u.user_name,
    COUNT(rev.rev_id) AS contribs
FROM
    user u
    INNER JOIN user_groups ug
    ON u.user_id = ug.ug_user
    INNER JOIN revision_userindex rev
    ON rev.rev_user = u.user_id
WHERE
    ug.ug_group IN ('sysop', 'bureaucrat', 'checkuser', 'oversight')
    AND rev.rev_timestamp >= 20150928000000
GROUP BY
    u.user_name

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20151028/df075029/attachment.html>