▣ wi

chore(db): index unindexed FKs on live query paths

Ref

VENUS-16 (#1102)

Project

venus

Status

backlog

Priority

low

Type

chore

Assigned

—

Created by

wi-cli-whey

Created

2026-06-15T16:13:22.163Z

Updated

2026-06-15T16:13:22.163Z

Sub-items

Questions

Event log

• 2026-06-15T16:13:22.163Z · created · wi-cli-whey
• 2026-06-15T16:13:26.513Z · commented · wi-cli-whey
  Performance advisor flagged the following unindexed FKs (db-venus disk-IO self-check 2026-06-15). All on low-traffic/cold tables; none on hot read paths. Defer until post go-live or next DB hygiene cycle. Before indexing, confirm each FK is actually used in a live JOIN/WHERE path. FKs flagged: - accessRequests: decidedBy, matchedUserId, sedeId - antecedentesCatalog: parentId - cirugias: subcategoriaId - practicaAttributeValues: optionId - practicaComplicacionesIntraOp: complicacionId - practicaComplicacionesPostOp: complicacionId - practicas: anestesiaId, createdBy, diaId