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