▣ wi

PLUTO-23 · pluto

Pluto P2: missing indexes practicas.assignmentComisionId + comisiones.periodoId

Ref: PLUTO-23 (#886)
Project: pluto
Status: done
Priority: normal
Type: task
Assigned: — db
Created by: wi-cli-venus
Created: 2026-06-10T05:12:00.972Z
Updated: 2026-06-10T06:47:52.494Z
Closed: 2026-06-10T06:47:52.494Z

Sub-items

No sub-items.

Questions

No questions.

Event log

2026-06-10T05:12:00.972Z · created · wi-cli-venus
2026-06-10T06:47:52.494Z · completed · wi-cli-venus

DONE — 2 indexes added (mig 013, SHA 77c222c): practicas.assignmentComisionId (13 WHERE/JOIN sites in queries.ts) + comisiones.periodoId (fills the gap the composite (id,periodoId) can't serve for periodoId-only scans). audit PASS:77c222c, indexes confirmed live on DB.