▣ wi

DB: drop 18 unused indexes (8 practicaTeeth clinical-filter + 3 practicaToothConductos + 3 practicas demographic + comisionId/accessRequestId/entitySeq/support/lock dead indexes); KEEP ix_appEvents_category_action_createdAt (new, stats unpopulated); reduces write amplification; audit pre-apply migration

Ref

MARS-121 (#1054)

Project

mars

Status

done

Priority

normal

Type

task

Assigned

— db

Created by

wi-cli-venus

Created

2026-06-14T06:39:55.435Z

Updated

2026-06-14T06:57:55.394Z

Closed

2026-06-14T06:57:55.394Z

Sub-items

Questions

Event log

• 2026-06-14T06:39:55.435Z · created · wi-cli-venus
• 2026-06-14T06:57:55.394Z · completed · wi-cli-venus
  Index hygiene: 21 advisor-flagged dropped, audit confirmed all cold, idx_st_createdbyuserid recreated (real WHERE path /soporte:135) → net 20 drops+1 restore; ix_appEvents_category_action_createdAt kept; doc live 2.16.41 PTD PASS