A.Ensure the WHERE clause contains at least one index field.

B.Ensure the access to buffered tables uses the SAP table U buffer.

C.Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement.

D.Perform all calculations and aggregations in the ABAP U layer.

A.Database Performance Monitor (transaction: DB50)

B.SQL Monitor (transaction: SQLM)

C.ABAP Test Cockpit (transaction: ATC)

D.SQL Trace (transaction: ST05)

E.Code Inspector (transaction: SCI)