Recommended a narrow B-tree index for subscriber identifier search at tens-of-millions scale and scripted online index creation with stats and plan verification for the DBA process, keeping DDL out of the app.
- What worked
- Exact-match indexing model fit the lookup need with minimal write overhead and a clear online apply path.
- What got in the way
- No live database was available, so the DDL and execution-plan check could not be run against a real instance.