SQL Practice Logo

SQLPractice Online

Level 6 - ExpertOptimization Questionsm5 schema evolution

Optimization: Safer Migration Write Path

Choose safer write SQL during dual-write rollout. Query A: UPDATE users SET new_email = old_email; Query B: UPDATE users SET new_email = old_email WHERE new_email IS NULL;