Expressing our Experience

SQL Statement Tuning # 3, SolutionDB, Solution Database

Another interesting tip on Expensive SQL Statements, it helps you to quickly find a solution for expensive sql statements that are originating from SAP Standard Programs/logics.

In general, once you have identified the SQL Statement which is causing the high response time, you should look into the Solution DB that is available from SAP. This particular option is most useful for the frequently faced performance issues with SAP Standard Programs, Tables,  Index, Functional Modules, etc.

Solution Database provides you with the pointers such as OSS Notes, Coding Change, Secondary Index Requirement, Statistics Parameters, Histograms, Table Modification, Reorganization, etc.,

Here is the URL to access the Expensive SQL Statements Solution DB:

https://websmp206.sap-ag.de/~sapidb/011000358700001413351999E

This might look like a small piece of information, but it is very useful for the known issues and helps you with the pointers to resolve the performance issues in a short timeframe.

Thanks

PrakashP