topic regarding select query in Application Development and Automation Discussions

regarding select query

Former Member — Fri, 31 Jul 2009 05:08:50 GMT

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.

Re: regarding select query

Former Member — Fri, 31 Jul 2009 11:32:00 GMT

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

Re: regarding select query

premal_mistry2 — Fri, 31 Jul 2009 11:33:26 GMT

Hi Manish,

Use FOR ALL ENTRIES. It is much more efficient.

Regards,

Premal

Re: regarding select query

Former Member — Fri, 31 Jul 2009 17:47:34 GMT

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