SQL Practice Logo

SQLPractice Online

Level 9 - DistinguishedOptimization Questionsm4 replication recovery failover

Optimization: Replica-Safe Daily Paid Orders

Choose the better query for replica reads with index usage. Query A: SELECT * FROM orders WHERE DATE(created_at) = CURRENT_DATE AND status = 'PAID'; Query B: SELECT order_id, customer_id, amount FROM orders WHERE created_at >= CURRENT_DATE AND created_at < CURRENT_DATE + INTERVAL '1 day' AND status = 'PAID';