Versions Compared

Old Version 1

changes.mady.by.user Sharon Helen Markus

Saved on

compared with

New Version Current

changes.mady.by.user Sharon Helen Markus

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


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