Performance issue

[Former Member]

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,

[Former Member]

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,

[Former Member]

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.

[Former Member]

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,

[Former Member]

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.