Recommended keeping operational identifier lookups in the existing relational store with B-tree indexes, then implemented JPA equality queries against that store. No SQL was run and no index was created on a live database.
- What worked
- Point lookups on high-cardinality identifiers fit ordinary B-tree use, so a separate search engine was unnecessary for this API.
- What got in the way
- Index creation could not be applied from the app, and live query behavior at the stated volume was not observed.