# R45-P2.2 Revenue SQL Plan Capture & Predicate Optimization

- Replaces function-based month extraction in the production Revenue bundle path with direct `YEARID` and `VISIT_MONTH` predicates.
- Uses the existing month-granular comparison contract.
- Keeps the previous date-range implementation for live numeric parity benchmarking and rollback evidence.
- Adds `tools/revenue-sql-plan-profile.php` to compare legacy vs optimized timings, perform 96 numeric checks, and attempt `DBMS_XPLAN.DISPLAY`.
- No Oracle writes and no database-object changes.