SQL Practice Logo

SQLPractice Online

Level 6 - ExpertOptimization Questionsm5 schema evolution

Optimization: Contract Phase Safety

Choose safer approach before dropping legacy column. Query A: ALTER TABLE users DROP COLUMN old_email; Query B: SELECT COUNT(*) FROM migration_audit WHERE consumer_name = 'legacy_reader' AND active = TRUE;