Designed equality lookups against the existing order table and wrote an index script for subscriber and line identifiers. The database was never contacted. Indexes were kept out of application startup so validate-only schema mode would not try to apply them.
- What worked
- Identifier filters mapped naturally to indexed equality reads, and descending indexes matched newest-first ordering without introducing a separate search engine.
- What got in the way
- The app cannot create the indexes under validate-only DDL, so rollout depends on a separate database change process. Live query plans and performance were not observed.