topic Performance Tuning in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/performance-tuning/m-p/9174239#M1712347 <HTML><HEAD></HEAD><BODY><P>Can Anyone suggest to optimise the below select queries for improve the performance. </P><P></P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">SELECT <SPAN class="L0S52">SINGLE </SPAN>ausme matnr werks<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">FROM </SPAN>marc <SPAN class="L0S52">INTO </SPAN><SPAN class="L0S55">(</SPAN>marc<SPAN class="L0S70">-</SPAN>ausme<SPAN class="L0S55">, </SPAN>marc<SPAN class="L0S70">-</SPAN>matnr<SPAN class="L0S55">, </SPAN>marc<SPAN class="L0S70">-</SPAN>werks<SPAN class="L0S55">)</SPAN><BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">WHERE </SPAN>matnr <SPAN class="L0S52">EQ LS_TAB</SPAN><SPAN class="L0S70">-</SPAN>matnr<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND </SPAN>werks <SPAN class="L0S52">EQ LS_TAB</SPAN><SPAN class="L0S70">-</SPAN>werks<SPAN class="L0S55">.</SPAN><BR /><BR /><BR /><BR />&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">SELECT </SPAN><SPAN class="L0S52">SINGLE </SPAN>msehi <SPAN class="L0S52">INTO LS_TAB</SPAN><SPAN class="L0S70">-</SPAN>vrkme <SPAN class="L0S52">FROM </SPAN>t006<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">WHERE </SPAN>isocode <SPAN class="L0S55">= LS_TAB</SPAN><SPAN class="L0S70">-</SPAN>vrkme<SPAN class="L0S55">.</SPAN></SPAN></P><P><SPAN class="L0S52"><SPAN class="L0S55"></SPAN></SPAN></P><P><STRONG><SPAN class="L0S52" style="color: #ff0000;"><SPAN class="L0S55">Moderator message: please do more research before posting, for example <A __default_attr="29243" __jive_macro_name="document" class="jive_macro jive_macro_document" href="https://community.sap.com/"></A></SPAN></SPAN></STRONG></P><P></P><P>Message was edited by: Thomas Zloch</P></BODY></HTML> Tue, 27 Nov 2012 12:19:40 GMT Former Member 2012-11-27T12:19:40Z Performance Tuning https://community.sap.com/t5/application-development-and-automation-discussions/performance-tuning/m-p/9174239#M1712347 <HTML><HEAD></HEAD><BODY><P>Can Anyone suggest to optimise the below select queries for improve the performance. </P><P></P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">SELECT <SPAN class="L0S52">SINGLE </SPAN>ausme matnr werks<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">FROM </SPAN>marc <SPAN class="L0S52">INTO </SPAN><SPAN class="L0S55">(</SPAN>marc<SPAN class="L0S70">-</SPAN>ausme<SPAN class="L0S55">, </SPAN>marc<SPAN class="L0S70">-</SPAN>matnr<SPAN class="L0S55">, </SPAN>marc<SPAN class="L0S70">-</SPAN>werks<SPAN class="L0S55">)</SPAN><BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">WHERE </SPAN>matnr <SPAN class="L0S52">EQ LS_TAB</SPAN><SPAN class="L0S70">-</SPAN>matnr<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND </SPAN>werks <SPAN class="L0S52">EQ LS_TAB</SPAN><SPAN class="L0S70">-</SPAN>werks<SPAN class="L0S55">.</SPAN><BR /><BR /><BR /><BR />&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">SELECT </SPAN><SPAN class="L0S52">SINGLE </SPAN>msehi <SPAN class="L0S52">INTO LS_TAB</SPAN><SPAN class="L0S70">-</SPAN>vrkme <SPAN class="L0S52">FROM </SPAN>t006<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">WHERE </SPAN>isocode <SPAN class="L0S55">= LS_TAB</SPAN><SPAN class="L0S70">-</SPAN>vrkme<SPAN class="L0S55">.</SPAN></SPAN></P><P><SPAN class="L0S52"><SPAN class="L0S55"></SPAN></SPAN></P><P><STRONG><SPAN class="L0S52" style="color: #ff0000;"><SPAN class="L0S55">Moderator message: please do more research before posting, for example <A __default_attr="29243" __jive_macro_name="document" class="jive_macro jive_macro_document" href="https://community.sap.com/"></A></SPAN></SPAN></STRONG></P><P></P><P>Message was edited by: Thomas Zloch</P></BODY></HTML> Tue, 27 Nov 2012 12:19:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-tuning/m-p/9174239#M1712347 Former Member 2012-11-27T12:19:40Z Re: Performance Tuning https://community.sap.com/t5/application-development-and-automation-discussions/performance-tuning/m-p/9174240#M1712348 <HTML><HEAD></HEAD><BODY><P>2. Please Read F1 help on Select Single&nbsp; From Transaction 'ABAPDocu'. Basic questions cannot be answered as per SCN Forum Rules</P></BODY></HTML> Tue, 27 Nov 2012 12:36:50 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-tuning/m-p/9174240#M1712348 Venkat_Sesha 2012-11-27T12:36:50Z