Skip to Content
0
Former Member
Sep 04, 2013 at 07:00 AM

Performance issue with the view WB2_V_MKPF_MSEG2

351 Views

Hi folks,

here i am fetching the data by using the view WB2_V_MKPF_MSEG2. But am not using the posting date (BUDAT) at where condition in the select stetement as per my requirement. So it needs to fetch the entire records available. For this execution it is almost taking 3 - 4 hours time. Please suggest me how to tune this up based on irrespective posting date at where condition in the select statement. below is the statement where getting struck for long time. below is the code.

SELECT xblnr werks_i matnr_i bwart_i menge_i dmbtr_i xauto_i budat umwrk_i mblnr mjahr

FROM wb2_v_mkpf_mseg2

INTO TABLE it_view1

WHERE MBLNR BETWEEN 4900000000 AND 4999999999

AND MBLNR_I BETWEEN 4900000000 AND 4999999999

AND ZEILE_I BETWEEN 1 AND 9999

AND MJAHR BETWEEN 2010 and 9999

AND MJAHR_I BETWEEN 2010 and 9999

* AND budat IN s_date

AND matnr_i IN s_matnr

AND werks_i IN s_werks

AND bwart_i IN ('ZE5','ZX5','ZD5','ZS5')

%_HINTS ORACLE '&max_in_blocking_factor 100&'.