Recommended keeping exact-key operator lookups on the existing relational system of record for a high-volume order workload, then implemented a non-unique B-tree index via a DBA-owned SQL script plus JPA mappings instead of adding a search engine. No live database was available to apply or exercise the index.
- What worked
- Equality lookups on the two identifier columns mapped cleanly to ordinary indexed table access. Online index creation SQL was straightforward and fit a schema-validate workflow where the app must not auto-migrate.
- What got in the way
- The new query and index build were never run against a live instance, so ingest rate, plan quality, and session-pool behavior at target scale were not observed.