Level 9 - DistinguishedDebugging Questionsm1 optimizer cardinality internals
Debug Function-Wrapped Predicate
Fix this query so the composite index can be used: SELECT order_id, amount FROM tenant_orders WHERE UPPER(tenant_key) = 'ACME' AND created_at >= DATE '2026-01-01';
Schema Context
tenant_orders(order_id, tenant_key, created_at, amount), index(tenant_key, created_at)