My MySQL database is structured so that each user has 9 items. Each item can have multiple numerical entries. What my query does is finds the maximum entry for each of those 9 items, then adds the largest value from each up.

I created 2 views to do portions of this:

CREATE ALGORITHM=MERGE VIEW SumCampaignScores AS
SELECT Sum(MaxCampaignScore) AS SumCampaignScore, Gamertag
FROM MaxCampaignScores GROUP BY Gamertag;

CREATE ALGORITHM=MERGE VIEW MaxCampaignScores AS
SELECT Max(Score) AS MaxCampaignScore, Gamertag, MissionID FROM CampaignMissions
GROUP BY Gamertag, MissionID;

How do I add indices for those?

This is a slow query, for example:
SELECT COUNT(*) FROM SumCampaignScores

Any suggestions?