SQL Query Optimization: Index columns used in join conditions

Created on 12 July 2024, 5 months ago

Problem/Motivation

There are no DB indexes defined beyond the primary keys; however, there are join patterns and other queries concerned with the existence of values that should be able to execute more efficiently by introducing some indexes, such as:

Steps to reproduce

Nothing really to reproduce, per se.

Proposed resolution

Introduce some indexes for columns often involved in query condition.

Remaining tasks

- get MR together
- review
- merge
- release

User interface changes

None.

API changes

None.

Data model changes

None, unless, DB indexes are considered part of the data model? In which case, it's just the introduction of the indexes.

📌 Task
Status

Active

Version

2.0

Component

Code

Created by

🇨🇦Canada adam-vessey PE, Canada

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Merge Requests

Comments & Activities

Production build 0.71.5 2024