You should test with realistic data before adding indexes in production.

1. Create only the necessary indexes for JOB A’s queries.
2. Benchmark JOB B’s performance in staging with those indexes to see the actual overhead.
3. If JOB B’s bulk writes slow down too much, consider:

• Dropping/rebuilding indexes around large loads

• Batching updates/inserts

• Using caching/materialized views for JOB A instead of hitting the base table directly