sql 查询优化实例

最新推荐文章于 2023-01-30 15:57:07 发布

eco_zhiyong

最新推荐文章于 2023-01-30 15:57:07 发布

阅读量426

点赞数

分类专栏： Android学习笔记文章标签：优化 sql date 2010

本文链接：https://blog.csdn.net/eco_zhiyong/article/details/6260697

版权

Android学习笔记专栏收录该内容

6 篇文章 0 订阅

订阅专栏

语句1：
SELECT account.alias,SUM(amount)
FROM expense,account
WHERE date>=20101101 AND date<=20101131 AND expense.act_id=account.act_id
GROUP BY expense.act_id

语句2：

SELECT account.alias,"SUM(amount)"
FROM account,(SELECT act_id,SUM(amount)
FROM expense
WHERE date>=20101101 AND date<=20101131
GROUP BY expense.act_id)as expenseact
WHERE account.act_id=expenseact.act_id

以上两查询语句结果一样。当两张表非常大时，效率上语句2 远高于语句1。