Here is a list of tips for optimizing queries written to be run against the LDP reporting database environment from the FOLIO community:

Basic tips for faster queries in LDP databases

• Indexes
• Vacuum analyze
• Temporary tables
• Breaking apart large queries
• Use NOT EXISTS instead of NOT IN
• Simple column names
• System configuration