Level 7 - ArchitectOptimization Questionsm1 indexing strategy
Optimization Showdown: Covering Projection
Choose better query and provide final SQL. Query A: SELECT * FROM orders WHERE customer_id = 9912 ORDER BY created_at DESC LIMIT 20; Query B: SELECT order_id, created_at, total_amount FROM orders WHERE customer_id = 9912 ORDER BY created_at DESC LIMIT 20;
Schema Context
orders(order_id, customer_id, created_at, total_amount, shipping_address, notes, metadata_json)