How to improve select stmt performance without going for secondary index
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,
Thomas Zloch 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.