mysql查询优化问题

【编程】 mysql查询优化问题

--------------------------------------------

傻大方资讯为您精选的网友回复(供您参考):

[手机]SELECT id,name,yueshi,xiaofei,shijian,huishi,keshi FROM y_guahao LEFT JOIN a_guanli ON y_guahao.yuangong = a_guanli.username这是我的sql语句,三万条记录查询用时4.5秒,请问各位大仙怎么优化,新手小白,下面是建立的索引急!!!

--------------------------------------------