记一次MYSQL索引优化
背景……巴拉巴拉(省略一千字),直接上sql吧~
原始SQL:
现:table_xcx、table_xgx数据量十万级别,table_xrx 数据量百万级别。
SELECT
c.id,
c.name,
c.phone,
IF( r.idcard IS NULL, c.idcard, r.idcard ) AS cid,
c.num,
IF( r.r_id IS NULL, 0, 1 ) AS rId,
IF( g.id IS NULL, 0, 1 ) AS gId,
FROM
tabl..
原创
2020-10-14 11:56:29 ·
150 阅读 ·
0 评论