Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Reduce number of disk reads for a select statement..

Hi Experts,

I had a Select statement like this ,

SELECT approval_agent

FROM zmep_sc_app_hist

INTO CORRESPONDING FIELDS OF TABLE t_tab_approval_agent

WHERE item_guid EQ us_sc_i_guid

AND appr_description NE c_con_valid.

which is causing high number disk reads in the Production system,

so i got a suggesion that,if we remove the Negative checks like " NE" in select statemant

and removing the "CORRESPONDING FILEDS ".... will improve performance..

Does this reduce the number of disk reads..?

please suggest if I change the above select like this does it improve performance..or decrease the disk reads ..

SELECT approval_agent

FROM zmep_sc_app_hist

INTO CORRESPONDING FIELDS OF TABLE t_tab_approval_agent

WHERE item_guid EQ us_sc_i_guid

Delete zmep_sc_app_hist where appr_description NE c_con_valid.

Regards

sivaram

Former Member
Not what you were looking for? View more on this topic or Ask a question