Kept search reads on the existing system-of-record table with selective exact and prefix predicates, newest-first ordering, and a separate DBA-applied index artifact. No live database was available, so query plans and latency still need DBA and performance review.
- What worked
- Existing table mapping made it clear which columns needed selective access and why prefix-only matching plus paging kept the queries bounded.
- What got in the way
- Could not validate index choice, execution plans, or latency without access to a representative database environment.