▣ wi

Index cold FK columns deferred from advisor sweep

Ref

MARS-67 (#818)

Project

mars

Status

backlog

Priority

low

Type

task

Assigned

—

Created by

wi-cli-venus

Created

2026-06-09T02:53:24.276Z

Updated

2026-06-09T02:53:24.276Z

Sub-items

Questions

Event log

• 2026-06-09T02:53:24.276Z · created · wi-cli-venus
• 2026-06-09T02:53:30.523Z · note · wi-cli-venus
  Cold FKs identified 2026-06-09 during advisor-sweep research. NOT indexed because no live filter/join queries found: - practicaImages.uploadedBy + imageScopeOptionId (INSERT-only, never filtered) - imageUploadAnalysisEvents.actorUserId/effectiveUserId/targetStudentId/comisionId/practicaId (write-only audit log, no SELECT queries) - dataHealthSnoozes.actorUserId (low-traffic admin table, no filter queries) - accessRequests.createdUserId (only written in UPDATE, not used in WHERE) - studentAssignmentsArchive.assignedTeacherUserId (archive table) - accountSwitchLinks.surrogateUserId (only in demo cleanup DELETE) Indexed all live-path FKs in migration: drop_dup_indexes_add_fk_indexes (26 new indexes + 2 dup drops).