Optimization
文章平均质量分 78
zyz511919766
这个作者很懒,什么都没留下…
展开
-
MySQL SQL优化案例:LIMIT M,N大偏移量分页
原查询语句:SELECT loan_document_id, contract_id, applicant_contract_id, buyer_id, buyer_name, seller_id, seller_name, loan_document_no, loan_document_type, order_content, amount,原创 2016-01-06 16:36:28 · 11011 阅读 · 2 评论 -
MySQL SQL优化案例:相关子查询(dependent subquery)优化
原始语句:SELECT t1.*FROM t_payment_bank_account_info t1WHERE EXISTS ( SELECT 1 FROM t_payment_account_dtl t2 WHERE t1.account_no = t2.account_no AND t2.parent_a原创 2016-01-06 16:42:35 · 15710 阅读 · 4 评论