|
egemen_ates
Yak Posting Veteran
76 Posts |
 Posted - 2012-05-23 : 05:26:19
|
| HOW CAN I IPMROVMENT PERFORMANCE OF THIS QUERY SELECT GC.PRODUCT_ID, GC.STOCK_ID, SFR.AMOUNT, SF.DEPARTMENT_IN, SF.DEPARTMENT_OUT, SF.LOCATION_IN, SF.LOCATION_OUT, GC.STOCK_IN, GC.STOCK_OUT, ((GC.MALIYET_2*ABS(GC.STOCK_IN-GC.STOCK_OUT))) AS TOTAL_COST_2, (GC.MALIYET*ABS(GC.STOCK_IN-GC.STOCK_OUT)) AS TOTAL_COST, (GC.MALIYET/(SF_M.RATE2/SF_M.RATE1)) MALIYET, (SFR.AMOUNT*ISNULL(COST_PRICE,0)) AS TOTAL_COST_PRICE, (SFR.AMOUNT*ISNULL(EXTRA_COST,0)) AS TOTAL_EXTRA_COST, SF.FIS_DATE ISLEM_TARIHI, SF.PROCESS_CAT, SF.FIS_TYPE PROCESS_TYPE, ISNULL(SF.PROD_ORDER_NUMBER,0) AS PROD_ORDER_NUMBER, ISNULL(SF.PROD_ORDER_RESULT_NUMBER,0) AS PROD_ORDER_RESULT_NUMBER FROM STOCK_FIS SF WITH (NOLOCK), STOCK_FIS_ROW SFR WITH (NOLOCK), STOCK_FIS_MONEY SF_M, GET_STOCKS_ROW_COST_LOCATION AS GC WHERE GC.UPD_ID = SF.FIS_ID AND SFR.FIS_ID= SF.FIS_ID AND GC.PROCESS_TYPE = SF.FIS_TYPE AND GC.STOCK_ID=SFR.STOCK_ID AND SF.FIS_TYPE IN (110,111,112,113,115,119) AND SF.FIS_DATE >= {ts '2012-05-01 00:00:00'} AND SF.FIS_DATE <= {ts '2012-05-23 00:00:00'} AND SF.FIS_ID = SF_M.ACTION_ID AND SF_M.MONEY_TYPE = 'TL'Table 'STOCK_FIS_MONEY'. Scan count 15, logical reads 42, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.Table 'STOCK_FIS_ROW'. Scan count 15, logical reads 58, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.Table 'SETUP_PERIOD'. Scan count 16, logical reads 32, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.Table 'Worktable'. Scan count 26, logical reads 231490, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.Table 'PRODUCT_COST'. Scan count 2, logical reads 7392, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.Table 'STOCKS_ROW'. Scan count 14, logical reads 79, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.Table 'STOCK_FIS'. Scan count 1, logical reads 14, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0. |
|
QUERY PERFORMANCE