Search problematic statements for the result of SELECT/OpenCursor without ORDER BY: Search for statements that rely on implicit sorting
Code Inspector checks to search for potential performance issues
Search problematic SELECT* Statements: Search for SELECT* statements where less than a certain percentage of the fields are used later.
Search DB operations in loops across modularization units: Search for repeated identical selects
Search SELECT…FOR ALL ENTRIES – clauses to be transformed: Search for SELECT Statements with FOR ALL ENTRIES that can be replaced by a SELECT statement with a join