create index idx_name on BeginLog(qqid); create index idx_name1 on CompletLog(qqid); create index idx_name2 on beginlog(matchid) create index idx_name3 on completlog(matchid)
create index xx1 on BeginLog(qqid,matchID,matchType); create index xx1 on CompletLog(gameEndType,qqid);
create index idx_name1 on CompletLog(qqid);
create index idx_name2 on beginlog(matchid)
create index idx_name3 on completlog(matchid)
create index xx1 on BeginLog(qqid,matchID,matchType);
create index xx1 on CompletLog(gameEndType,qqid);