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
  • No labels