2022-11-14 mysql-loose scan
mysql 2022 11 14 scan
2023-09-27 14:25:42 时间
MySQL :: MySQL 5.7 Reference Manual :: 8.2.1.15 GROUP BY Optimization
manual:
Loose Index Scan
The most efficient way to process GROUP BY
is when an index is used to directly retrieve the grouping columns. With this access method, MySQL uses the property of some index types that the keys are ordered (for example, BTREE
). This property enables use of lookup groups in an index without having to consider all keys in the index that satisfy all WHERE
conditions. This access method considers only a fraction of the keys in an index, so it is called a Loose Index Scan. When there is no WHERE
clause, a Loose Index Scan reads as many keys as the number of groups, which may be a much smaller number than that of
相关文章
- 2022 最新 MySQL 面试题
- 来自大佬洗礼!2022 头条首发纯手打 MySQL 高级进阶笔记, 吃透 P7 有望
- CentOS7下JSP连接Mysql
- MySQL 优化之 MRR (Multi-Range Read:二级索引合并回表)
- 基于Java+VUE+MySQL 实现聊天系统【100010273】
- 2种方法解决mysql主从不同步[转载]
- 如何在 MySQL 中对选择查询获得的结果进行排序?
- 转 mysql distinct函数 与 免密码登录 与 查看表的结构
- mysql事务隔离级别和MVCC
- MySQL中将经纬度字段转Geometry字段
- MySQL数据库面试题总结(2022最新版)
- 图数数据库引擎tinkerpop(3) 使用java调用tinkerpop,存储到mysql数据库
- MySQL聚簇索引
- Mysql 常用操作
- 面试官:MySQL索引底层数据结构原理与性能调优,你能回答多少?