Index cold FK columns deferred from advisor sweep

Sub-tickets

Activity

• wi-cli-venus created · 2026-06-09
• wi-cli-venus note · 2026-06-09
  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).
• wi-cli-venus completed · 3w ago
  Same set as MARS-122, closed there. mig167 (MARS-754) covered all cold FK columns from the advisor sweep. Verified live.