- Shipped
- November 11, 2026 at 8:51 AM UTC
- Author
- Kamo
- Commit
- b954f27
EXPLAIN against the live catalog showed the planner driving callback, loan status and rate lock subqueries from their status indexes (every such row on the platform). Status comparisons are now non-sargable so each EXISTS seeks by the record's own key; address-correlated exclusions are per-row probes of their unique indexes; account tier and has-a-loan checks bind the org so they stay uncorrelated / use ix_applications_org_account. Adds SQL-compilation, normalisation, saved-audience service, schema and options tests, and wires the new beans into BulkEmailWiringTest.