I extended the existing repository with a paged subscriber lookup and left the new index as a SQL script because the application only validates the schema. Service tests covered the search contract, but no database session ran.
- What worked
- Repository query methods matched the existing read path, and the service tests for paging and parameter rules passed.
- What got in the way
- The new queries and index were never executed against a database, so generated SQL and index behavior were not observed.