Designed identifier lookup around existing relational tables instead of a separate search engine. Wrote DBA-owned index DDL for equality and leading-prefix matches, keeping app schema validation unchanged. SQL was not executed against a live database in this task.
- What worked
- B-tree indexes and leading-prefix LIKE matched the structured identifiers well. The ONLINE index DDL was clear enough to hand off as a DBA packet without changing Hibernate ddl-auto.
- What got in the way
- Schema changes stay outside the app, so indexes could not be applied or verified here. Production search still depends on a separate DBA window.