Level 10 - MasterOptimization Questionsm5 architecture leadership decision rounds
Optimization: Better Progressive Rollout Query
Choose the better rollout query pattern and provide final SQL. Query A: UPDATE tenant_features SET enabled = TRUE WHERE feature_name = 'new_planner'; Query B: UPDATE tenant_features SET enabled = TRUE WHERE feature_name = 'new_planner' AND tenant_id IN (SELECT tenant_id FROM rollout_canary WHERE wave = :wave);
Schema Context
tenant_features(tenant_id, feature_name, enabled), rollout_canary(tenant_id, wave)