关于mysql语句的问题 ( 积分: 50 )

select distinct a.frulestwo
from t_opernet_log a right join t_opernet_log b
on cast(b.FRegTime as datetime )>= cast(a.FRegTime as datetime ) - interval 10 MINUTE
and cast(b.FRegTime as datetime )<= cast(a.FRegTime as datetime ) + interval 10 MINUTE
and a.FServerMAC = b.FServerMAC
where a.FRulesTwo ='haiy_87@hotmail.com'
表t_opernet_log 中有100000条记录 查询太慢了，哪位老师帮忙看一下语句时不是有问题

select distinct a.frulestwo
from .....
where a.FRulesTwo ='haiy_87@hotmail.com'
看你代码后，觉得有点问题：distinct的作用是取得不重复的a.frulestwo，
而最后where语句的条件是a.FRulesTwo ='haiy_87@hotmail.com'，是不是
有点前后矛盾。。
小弟是菜鸟，说错了不要笑话偶啊，关注ing ！！！[]

a.FRulesTwo 建索引
a.FServerMAC建索引