遇到慢SQL该怎么办?(下)|sql|阈值|索引|hash|query_网易订阅

select*frombmsql_stockwheres_w_idin(1,10,100)ors_i_idin(1,10)将selfjoin查询拆分为效率更高两个子查询1)selfjoin查询。2)where子句包含相同列差值的范围查询。例如1通过等值谓词加快查询速度selecta.c_idfrombmsql_customera,bmsql_customerbwherea.c_id...