Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to improve select stmt performance without going for secondary index

Hi friends,

I have a select statement which does not contains key fields(Primary index) in where condition. And I have to improve that select stmt performance without going for the secondary indexes.

Can you plese suggest the alternative way for this?.

Thanks in advance,

Ramesh.

Former Member
replied

Table buffering is only suitable for tables that don't have too many entries are being changed rather infrequently. In general, you will see most customizing tables being buffered, but hardly any application data tables (maybe some master data, but no movement data).

So buffering cannot be the general answer here. Tell your boss it is impossible to have a simple answer for this problem, the actual case has to be analysed. For example, you can avoid creating a secondary index on VBRP fields AUBEL and AUPOS, if you know how to use table VBFA. In rare cases, a new secondary index cannot be avoided if performance is a big issue.

Thomas

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question