请教 索引倒序扫描的问题 ( Backward index scan)
SQL 排序是根据主键 id 来排的,但是 explain 显示已经命中了非聚簇索引,为什么还能够使用 Backward index scan 呢?
select
*
from
`transport_bills`
where
`driver_uuid` = '1128051427252'
and `freight_bill_pay_time` between '2023-11-01 00:00:00' and '2023-11-30 23:59:59'
order by
`id` desc
推荐文章: