topic Performance issue in Application Development and Automation Discussions

Performance issue

Former Member — Wed, 25 Jul 2007 14:00:43 GMT

Hi,

I want to access the data from table BVOR, The only where clause which i m using is BUKRS, Its not fully specified Key, so thas why its taking a huge time for data retrieval for this select statement. How can I improve performance in this case. What if I use buffering for this table? What are the other solutions for performance improvement.

Thanks,

Re: Performance issue

Former Member — Wed, 25 Jul 2007 14:02:46 GMT

Hi,

You can create a index for the table BVOR with key BUKRS.

Also you can try to give more conitions in the where clause.

Reward if helpful.

Re: Performance issue

Former Member — Wed, 25 Jul 2007 14:18:04 GMT

well for this table SAP has not mantained technical settings, If i create technical setting myself, is there any problem? Give me comments on Buffering this table...

Thanks,

Re: Performance issue

Former Member — Wed, 25 Jul 2007 14:39:14 GMT

Why you want to change technical setting. Define new Secondary index as per your requirement, and use in your report so performance will be increase.