regarding select query

[Former Member]

hi gurus,

iam using one select query with joins... but it fetches data from table that having lakhs of data... so the query is giving performance issue, so what select query i will write to solve this issue...

THE CODE IS IS GIVEN BELOW

SELECT A_{BLDAT A}BUDAT A_{CPUDT B}MATNR SUM( B_{MENGE ) B}BWART

INTO TABLE ITAB FROM MKPF AS A

INNER JOIN

MSEG AS B

ON B_{MBLNR = A}MBLNR AND B_{MJAHR = A}MJAHR

WHERE A~BLDAT IN ZDATE AND

B~BWART IN ('131', '132') AND

B~LGORT = 'FG01' AND

B_{KZBEW = 'F' GROUP BY A}BLDAT A_{BUDAT A}CPUDT B_{MATNR B}BWART.

LOOP AT ITAB.

CNT = CNT + 1.

ITAB2-CNT = CNT.

ITAB2-BLDAT = ITAB-BLDAT.

ITAB2-BUDAT = ITAB-BUDAT.

ITAB2-CPUDT = ITAB-CPUDT.

ITAB2-MATNR = ITAB-MATNR.

ITAB2-MENGE = ITAB-MENGE.

ITAB2-BWART = ITAB-BWART.

[Former Member]

Check you may use the view: WB2_V_MKPF_MSEG2. This may save you from joining two tables.

Use for all entries instead of join.

Try and compare the two select queries through a trace ST05.

I have seen the Select for all entries is far better in performance.

Edited by: jaya rangwani on Jul 31, 2009 1:33 PM

[premal_mistry2]

Hi Manish,

Use FOR ALL ENTRIES. It is much more efficient.

Regards,

Premal

[Former Member]

check for indexes in the table and if any index matches your where condition then use it in the same sequence.