SQL Practice Logo

SQLPractice Online

Level 6 - ExpertOptimization Questionsm5 schema evolution

Optimization: Index Migration Sequence

Select the safer sequence step first. Query A: DROP INDEX idx_orders_customer_created_at; Query B: CREATE INDEX idx_orders_customer_created_at_v2 ON orders (customer_id, created_at DESC);