press
press copied to clipboard
Add manually added DB indexes to source control
Move the source of truth to source control. Write a script to show indexes that aren't committed to git (with schema definitions or on_doctype_update etc).
We've seen performance regressions, because these indexes are removed (accidentally e.g. Framework change) or intentionally.
These removals often go unnoticed and cause unnecessary investigation delays.