-
SQL语句效率分析
第一种写法:
语句执行花费时间(毫秒) 330
SELECT
VGoodsLocationC,
Vtrancode,
VStartPoint,
V_OldGBGrade,
V_GBGrade,
SUM(IPackageCount) AS IPackageCount,
SUM(NWeight) AS NWeight
INTO ##storInTemp
FROM
V_InStorehouseInfo
WHERE VGoodsLocationC
IN (SELECT VGoodsLocationC FROM V_InStorehouseInfo)
or VGoodsLocationC in (SELECT VGoodsLocationC_In FROM V_StorMoveInfo)
GROUP BY
VGoodsLocationC,Vtrancode,VStartPoint,V_OldGBGrade,V_GBGrade
第二种写法:
语句执行花费时间(毫秒) 563
SELECT
VGoodsLocationC,
Vtrancode,
VStartPoint,
V_OldGBGrade,
V_GBGrade,
SUM(IPackageCount) AS IPackageCount,
SUM(NWeight) AS NWeight
INTO ##storInTemp
FROM (
SELECT
VGoodsLocationC,
Vtrancode,
VStartPoint,
V_OldGBGrade,
V_GBGrade,
IPackageCount,
NWeight
FROM V_InStorehouseInfo
WHERE VGoodsLocationC
IN (SELECT VGoodsLocationC FROM V_InStorehouseInfo)
UNION ALL
SELECT
VGoodsLocationC,
Vtrancode,
VStartPoint,
V_OldGBGrade,
V_GBGrade,
IPackageCount,
NWeight
FROM V_InStorehouseInfo
WHERE VGoodsLocationC
IN (SELECT VGoodsLocationC_In FROM V_StorMoveInfo)
) A
GROUP BY
VGoodsLocationC,Vtrancode,VStartPoint,V_OldGBGrade,V_GBGrade
Why?
-
相关阅读:
Android textAppearance的属性设置及TextView属性详解
Eclipse Hot Keys
面向对象(一)
Java基础知识(下)
code2uml使用教程
AndroidDevTools简介
idea2020.3 安装插件JetBrains 插件市场安装 Cloud Toolkit
在 Mac 上撰写和格式化备忘录-添加提醒-添加日历
macbook-键盘连击问题002
创业团队建设与管理
-
原文地址:https://www.cnblogs.com/pingkeke/p/559202.html
Copyright © 2020-2023
润新知