topic Re: Performance analysis in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/performance-analysis/m-p/4350096#M1035998 <HTML><HEAD></HEAD><BODY><P>This message was moderated.</P></BODY></HTML> Thu, 28 Aug 2008 06:58:06 GMT Former Member 2008-08-28T06:58:06Z Performance analysis https://community.sap.com/t5/application-development-and-automation-discussions/performance-analysis/m-p/4350095#M1035997 <HTML><HEAD></HEAD><BODY><P>SELECT objnr</P><P> FROM onr00</P><P> INTO TABLE t_1</P><P> WHERE objnr IN t_2.</P><P></P><P>In t_2 internal table all objnr values contains wild card u2018*u2019.</P><P></P><P>It is taking lot of database time. ONR00 table has almost 14 lakhs records. If we use internal table also it takes time. But what do you people suggest the solution for it.</P></BODY></HTML> Thu, 28 Aug 2008 06:43:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-analysis/m-p/4350095#M1035997 Former Member 2008-08-28T06:43:17Z Re: Performance analysis https://community.sap.com/t5/application-development-and-automation-discussions/performance-analysis/m-p/4350096#M1035998 <HTML><HEAD></HEAD><BODY><P>This message was moderated.</P></BODY></HTML> Thu, 28 Aug 2008 06:58:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-analysis/m-p/4350096#M1035998 Former Member 2008-08-28T06:58:06Z Re: Performance analysis https://community.sap.com/t5/application-development-and-automation-discussions/performance-analysis/m-p/4350097#M1035999 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>Declare internal table t_2 as RANGES.</P></BODY></HTML> Thu, 28 Aug 2008 07:00:47 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-analysis/m-p/4350097#M1035999 Former Member 2008-08-28T07:00:47Z Re: Performance analysis https://community.sap.com/t5/application-development-and-automation-discussions/performance-analysis/m-p/4350098#M1036000 <HTML><HEAD></HEAD><BODY><P>Declaration part:</P><P></P><P>TYPES: tp_objnr TYPE RANGE OF j_objnr.</P><P>DATA: t_objnr TYPE tp_objnr</P></BODY></HTML> Thu, 28 Aug 2008 07:07:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-analysis/m-p/4350098#M1036000 Former Member 2008-08-28T07:07:38Z Re: Performance analysis https://community.sap.com/t5/application-development-and-automation-discussions/performance-analysis/m-p/4350099#M1036001 <HTML><HEAD></HEAD><BODY><P>Sorry.</P><P>Here is the correct one.</P><P></P><P>TYPES: tp_objnr TYPE RANGE OF j_objnr.</P><P>DATA: t_2 TYPE tp_objnr</P><P></P><P>Edited by: lalitha botla on Aug 28, 2008 9:12 AM</P></BODY></HTML> Thu, 28 Aug 2008 07:12:12 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-analysis/m-p/4350099#M1036001 Former Member 2008-08-28T07:12:12Z Re: Performance analysis https://community.sap.com/t5/application-development-and-automation-discussions/performance-analysis/m-p/4350100#M1036002 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><PRE><CODE><P></P><P>In t_2 internal table all objnr values contains wild card u2018*u2019.</P><P></P></CODE></PRE><P></P><P>Show sample of value in t_2 ...</P></BODY></HTML> Thu, 28 Aug 2008 07:21:11 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-analysis/m-p/4350100#M1036002 Former Member 2008-08-28T07:21:11Z Re: Performance analysis https://community.sap.com/t5/application-development-and-automation-discussions/performance-analysis/m-p/4350101#M1036003 <HTML><HEAD></HEAD><BODY><P>LMREPT0201785001*</P></BODY></HTML> Thu, 28 Aug 2008 08:30:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-analysis/m-p/4350101#M1036003 Former Member 2008-08-28T08:30:02Z