首页 > 其他分享 >利用延迟关联或者子查询优化超多分页场景

利用延迟关联或者子查询优化超多分页场景

时间:2022-12-12 17:01:31浏览次数:42  
标签:20 分页 demo EXPLAIN 超多 300000 id 延迟

 

 

EXPLAIN
SELECT * FROM `demo` limit 300000,20

 

 

 

EXPLAIN
SELECT a.* FROM demo a, (select id from demo LIMIT 300000,20 ) b where a.id=b.id

 

标签:20,分页,demo,EXPLAIN,超多,300000,id,延迟
From: https://www.cnblogs.com/ooo0/p/16976525.html

相关文章