Optimization Showdown: Local vs Global Index Filter

Choose better design for time-partitioned orders with frequent tenant+time queries. Query A: Global index on (tenant_id, status) Query B: Local index on each partition (tenant_id, created_at, status)