Welcome To Ask or Share your Answers For Others

select * from table where id > x limit 10 执行流程？

asked Feb 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

select * from table where id > x limit 10 执行流程？
假设table有100W条数据，x=1W，那么数据库是找到1w以后的99W行记录然后取出前10条吗?还是只取出10001~10010这10条数据？

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

1.0k views

Welcome To Ask or Share your Answers For Others

1 Answer

answered Feb 6, 2021 by 深蓝 (71.8m points)

磁盘上就近找10个大于1W的

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

...