
SUM与GROUP BY语句的优化
一.SUM与GROUP BY语句的优化: 1.原语句为:SELECT IID.INVENTORY_ITEM_ID, SUM(IID.AVAILABLE_TO_PROMISE_DIFF), SUM(IID.QUANTITY_ON_HAND_D...
一.SUM与GROUP BY语句的优化: 1.原语句为:SELECT IID.INVENTORY_ITEM_ID, SUM(IID.AVAILABLE_TO_PROMISE_DIFF), SUM(IID.QUANTITY_ON_HAND_D...