topic Re: Select Statement in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/select-statement/m-p/6021517#M1347725 <HTML><HEAD></HEAD><BODY><P>Select statement has long response time.</P><P></P><P>Long database request time caused by too many buffers.</P><P></P><P>Many data blocks are scanned to find the selected records.</P><P></P><P>This affects the performance of program.</P></BODY></HTML> Fri, 07 Aug 2009 14:25:00 GMT Former Member 2009-08-07T14:25:00Z Select Statement https://community.sap.com/t5/application-development-and-automation-discussions/select-statement/m-p/6021515#M1347723 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I am a beginner in ABAP.</P><P></P><P>I want to ask how use of select statement affects the performance?</P></BODY></HTML> Fri, 07 Aug 2009 14:18:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-statement/m-p/6021515#M1347723 Former Member 2009-08-07T14:18:06Z Re: Select Statement https://community.sap.com/t5/application-development-and-automation-discussions/select-statement/m-p/6021516#M1347724 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>It depends of how you use SELECT statement. There are some recommended apporaches and the ones that should generally be avoided due to poor performance.</P><P>Please refer [Performance tuning|http://sapbrainsonline.com/ARTICLES/TECHNICAL/optimization/optimization.html]</P><P></P><P>You may also take a look at <SPAN __jive_macro_name="thread" id="1189383"></SPAN></P><P></P><P>Regards</P><P>Marcin</P><P></P><P>Edited by: Marcin Pciak on Aug 7, 2009 4:25 PM</P></BODY></HTML> Fri, 07 Aug 2009 14:24:39 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-statement/m-p/6021516#M1347724 MarcinPciak 2009-08-07T14:24:39Z Re: Select Statement https://community.sap.com/t5/application-development-and-automation-discussions/select-statement/m-p/6021517#M1347725 <HTML><HEAD></HEAD><BODY><P>Select statement has long response time.</P><P></P><P>Long database request time caused by too many buffers.</P><P></P><P>Many data blocks are scanned to find the selected records.</P><P></P><P>This affects the performance of program.</P></BODY></HTML> Fri, 07 Aug 2009 14:25:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-statement/m-p/6021517#M1347725 Former Member 2009-08-07T14:25:00Z