Recommendations

Optimize provides recommendations focused on performance improvements such as indexing issues, excessive data retrieval, and inefficient query patterns. Recommendations include:

• Excessive number of rows returned
• Full table scans caused by LIKE operations
• Queries on unindexed columns
• Repeated query
• Overfetching
• Using @db.Money
• Using @db.Char(n)
• Using @db.VarChar(n)
• Using timestamp(0) or timestamptz(0)
• Using CURRENT_TIME
• Storing large objects or BLOBs in the database
• Indexing on unique columns
• Long-running transactions
• Unnecessary indexes

Learn more about the recommendations generated by Optimize here.