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
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&'.