1. 大表拆分,拆分后可使用union all进行连接查询如:
SELECT * FROM `alarm` union all SELECT * FROM alarm_flow_metadata;
2. order by 优化,因order by操作过程中会存在排序操作,如果不关注分组后顺序问题可
使用order by null关闭排序操作。如:
EXPLAIN SELECT
eventId,
COUNT(*) AS sumid
FROM
ss_event
WHERE
eventTime between '2021-05-01 00:00:00'
AND '2021-05-02 23:59:59'
GROUP BY
eventId
order by null
3. 当查询某条数据是否存在时候可以使用limit1的形式如:
select 1 from admin where userId = '1' limit 1