Implemented exact identifier lookup against the existing relational table instead of adding a search engine. Wrote online B-tree index DDL and JPA index metadata; no live database session was used, so runtime behavior was not observed.
- What worked
- Equality lookups and online index creation mapped cleanly onto the existing system of record, and the SQL surface for a non-unique identifier index was clear.
- What got in the way
- Schema was owned outside the app, so the index could only be delivered as a script for a separate change process rather than applied during implementation.