topic Re: Performance in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/4037855#M965110 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Second select query is better because in the first one sorting has been done at the DATABASE level so it will put more load on the database wheraeas second sorting is at internal table.</P><P></P><P></P><P>Hope it helps you.</P><P></P><P>Reward if helpful.</P></BODY></HTML> Wed, 18 Jun 2008 07:27:08 GMT Former Member 2008-06-18T07:27:08Z Performance https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/4037852#M965107 <HTML><HEAD></HEAD><BODY><P>Hi gurus,</P><P></P><P>i want to know which is performed better</P><P></P><P></P><UL><LI level="1" type="ul"><P>SELECT VBELN</P></LI></UL><P>FKART</P><P>FKTYP</P><P>VBTYP</P><P>WAERK FROM VBRK INTO TABLE IT_VBRK WHERE FKTYP = '736738' ORDER BY VBTYP.</P><P> </P><P> OR</P><UL><LI level="1" type="ul"><P>SELECT VBELN</P></LI></UL><P>FKART</P><P>FKTYP</P><P>VBTYP</P><P>WAERK FROM VBRK INTO TABLE IT_VBRK WHERE FKTYP = '736738' .</P><P></P><P>SORT IT_VBRK BY I_VBTYP.</P><P></P><P>Regards</P></BODY></HTML> Wed, 18 Jun 2008 07:20:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/4037852#M965107 Former Member 2008-06-18T07:20:29Z Re: Performance https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/4037853#M965108 <HTML><HEAD></HEAD><BODY><P>2nd one will be better..</P><P>coz in the first one...the select query ll take longer time...as u are doing an additional task of sorting....</P><P></P><P></P><P>Reward points...if the ans if helpful <SPAN __jive_emoticon_name="happy"></SPAN></P><P></P><P>Regards</P><P>Rudra</P><P></P><P>Edited by: Rudra Prasanna Mohapatra on Jun 18, 2008 9:24 AM</P></BODY></HTML> Wed, 18 Jun 2008 07:22:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/4037853#M965108 former_member195383 2008-06-18T07:22:31Z Re: Performance https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/4037854#M965109 <HTML><HEAD></HEAD><BODY><P>2ed select is better</P><P></P><P>Edited by: S.r.v.r.Kumar on Jun 18, 2008 12:53 PM</P></BODY></HTML> Wed, 18 Jun 2008 07:22:54 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/4037854#M965109 Former Member 2008-06-18T07:22:54Z Re: Performance https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/4037855#M965110 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Second select query is better because in the first one sorting has been done at the DATABASE level so it will put more load on the database wheraeas second sorting is at internal table.</P><P></P><P></P><P>Hope it helps you.</P><P></P><P>Reward if helpful.</P></BODY></HTML> Wed, 18 Jun 2008 07:27:08 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/4037855#M965110 Former Member 2008-06-18T07:27:08Z Re: Performance https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/4037856#M965111 <HTML><HEAD></HEAD><BODY><P>thank you</P></BODY></HTML> Wed, 18 Jun 2008 07:37:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/4037856#M965111 Former Member 2008-06-18T07:37:21Z