2637345 - Expensive SQL with missing where predicates from FAE statements

To be applicable, all three of the following symptoms must be observed:

• You notice long-running/expensive SQL queries running in SM50/SM66 (sequential read) or find exepensive SQL in an ST12/ST05 trace.

.

• The expensive statement contains no predicates in the WHERE clause except for the client (MANDT/MANDANT/CLIENT).

.

• The ABAP statement (from which the native SQL originates) contains a FOR ALL ENTRIES (FAE) clause.

If the query is captured in an ST05 trace, select the problem line and click the Display ABAP Call Location button

And ST05 will take you to the source of the SQL statement

SAP Netweaver

IS NOT INITIAL , KBA , performance , SV-PERF , Performance Problems , Problem