MySql in 查询和其他查询效率对比

最新推荐文章于 2023-12-21 15:01:24 发布

颜值即正义

最新推荐文章于 2023-12-21 15:01:24 发布

阅读量3.5k

点赞数

CC 4.0 BY-SA版权

分类专栏： SQL

本文链接：https://blog.youkuaiyun.com/liu538430/article/details/88110836

数据库表数据在 100万，in 匹配数据在500条左右。

匹配字段已经建立了索引。

1.

select f.recordType,f.id,f.selectMonthGroup from ftms_fly_training_record f where f.selectMonthGroup in
('1970-01','1970-02','1970-03','1970-04','1970-05','1970-06','1970-07','1970-08','1970-09','1970-10','1970-11','1970-12','1971-01','1971-02','1971-03','1971-04','1971-05','1971-06','1971-07','1971-08','1971-09','1971-10','1971-11','1971-12','1972-01','1972-02','1972-03','1972-04','1972-05','1972-06','1972-07','1972-08','1972-09','1972-10','1972-11','1972-12','1973-01','1973-02','1973-03','1973-04','1973-05','1973-06','1973-07','1973-08','1973-09','1973-10','1973-11','1973-12','1974-01','1974-02','1974-03','1974-04','1974-05','1974-06','1974-07','1974-08','1974-09','1974-10','1974-11','1974-12','1975-01','1975-02','1975-03','1975-04','1975-05','1975-06','1975-07','1975-08','1975-09','1975-10','1975-11','1975-12','1976-01','1976-02','1976-03','1976-04','1976-05','1976-06','1976-07','1976-08','1976-09','1976-10','1976-11','1976-12','1977-01','1977-02','1977-03','1977-04','1977-05','1977-06','1977-07','1977-08','1977-09','1977-10','1977-11','1977-12','1978-01','1978-02','1978-03','1978-04','1978-05','1978-06','1978-07','1978-08','1978-09','1978-10','1978-11','1978-12','1979-01','1979-02','1979-03','1979-04','1979-05','1979-06','1979-07','1979-08','1979-09','1979-10','1979-11','19