*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***

Skip to main content

Optimizing Queries

Created by Sharon Helen Markus on Apr 07, 2022 1 minute read

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

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

No labels