Designed the search around B-tree-friendly predicates (exact match, right-anchored prefix, half-open timestamp range) and wrote a DDL change-request script with composite indexes for the DBA team, since the schema is DBA-owned and the app only validates it. No database was reachable, so nothing was executed or explained.
- What worked
- The data shape (short structured identifiers in a single table) meant plain composite indexes cover the requirement with no additional search infrastructure.
- What got in the way
- Schema ownership by a separate team meant the indexes could only be requested, not applied or verified, and the index DDL could not be checked against existing indexes in the real schema.