|
egemen_ates
Yak Posting Veteran
Turkey
63 Posts |
 Posted - 06/18/2012 : 05:18:05
|
i want to create index on view but im using derivate table please i need to optimize my query.my query show belown.
SELECT
ROUND(SUM(REAL_STOCK),4) REAL_STOCK,
ROUND(SUM(PRODUCT_STOCK),4) PRODUCT_STOCK,
ROUND(SUM(PRODUCT_STOCK+RESERVED_STOCK),4) SALEABLE_STOCK,
ROUND(SUM(PURCHASE_ORDER_STOCK),4) PURCHASE_ORDER_STOCK,
PRODUCT_ID,
STOCK_ID FROM (
SELECT
(SR.STOCK_IN - SR.STOCK_OUT) AS REAL_STOCK,
0 AS PRODUCT_STOCK,
0 AS RESERVED_STOCK,
0 AS PURCHASE_ORDER_STOCK,
SR.STOCK_ID,
SR.PRODUCT_ID
FROM
DBO.STOCK_123 SR
UNION ALL
SELECT
0 AS REAL_STOCK,
(SR.STOCK_IN - SR.STOCK_OUT) AS PRODUCT_STOCK,
0 AS RESERVED_STOCK,
0 AS PURCHASE_ORDER_STOCK,
SR.STOCK_ID,
SR.PRODUCT_ID
FROM
dbo.STOCK_123_DENEME SL,
DBO.STOCK_123 SR
WHERE
SR.STORE =SL.DEPARTMENT_ID
AND SR.STORE_LOCATION=SL.LOCATION_ID
AND SL.NO_SALE = 0)AS T
GROUP BY
PRODUCT_ID,
STOCK_ID |
|
Indexed view help (immediate)
