Optimization: Sargable Date Filter

Interviewer prompt: Choose the better query for index use on order_ts. Query A: SELECT * FROM orders WHERE DATE(order_ts) = DATE '2026-03-01'; Query B: SELECT * FROM orders WHERE order_ts >= TIMESTAMP '2026-03-01 00:00:00' AND order_ts < TIMESTAMP '2026-03-02 00:00:00';