Reviewed existing service configuration and repository code that pointed at the established enterprise database. Recommended staying on that store with partitioning and a secondary index instead of adding external search infrastructure.
- What worked
- Existing configuration and data-access patterns made it clear that exact identifier lookup could be handled transactionally without dual-write complexity.