Capture the SQL profile of an application

Search the problematic SELECT * statements

Display the execution plan of an SQL statement

Combine static and dynamic performance analysis results

Use of Native SQL and DB Hints

Existence check for Secondary Indexes

Direct access to Table Pools/Cluster

Missing ORDER BY or SORT after SELECT

Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement

Perform all calculations and aggregations in the ABAP layer

Ensure the WHERE clause contains at least one index field

Ensure the access to buffered tables uses the SAP table buffer

All classical open SQL statements in your program will become invalid

All ABAP variables must be escaped with a preceding @ sign

All fields in the GROUP BY clause must be separated by commas

All arithmetic expressions can be used for all types of variables

The full-text index is always updated asynchronously

SAP HANA has to be the primary database to create a full text search

The LIKE operator is required in your SELECT statement to implement fuzzy logic

The SCORE ( ) function is required to ensure the best hits of your search appear on top