性能从最好到最差:null > system > const > eq_ref > ref > range > index > all
explain select user_id,invite_user_id,count(id) as invite_num,invite_time from user where invite_user_id != 0 group by invite_user_id;
MySQL 查询效率
最新推荐文章于 2024-01-09 14:54:26 发布
性能从最好到最差:null > system > const > eq_ref > ref > range > index > all
explain select user_id,invite_user_id,count(id) as invite_num,invite_time from user where invite_user_id != 0 group by invite_user_id;