mysql 日期date 索引技巧
explain
select
time
AS timeStr,
after_order_confirm_num,
after_order_toshop_num,
after_order_invalid_num,
after_order_num,
ifnull(after_order_source_json,’[]’) after_order_source_json
from report_scrm
where is_deleted=0 AND business_type=0
AND time
>= ‘2021-01-28’ AND time
<= ‘2021-01-28’
最后发现了一些规律,但不知道是否有普遍性,即:
在查询数据条数约占总条数五分之一以下时(是不是5分之一不确定,就是结果集少的话)能够使用到索引