Before vs After — generated by myflames
Matches use operator and tree structure. Changed labels show before → after. Single-run timings are observations, not proof of a sustained improvement.
| Operator | Self-time (before) | Self-time (after) | Rows (before) | Rows (after) | Loops (before) | Loops (after) | Delta |
|---|---|---|---|---|---|---|---|
| Filter: ((joinit.i > 50)) REMOVED | 2.62 ms | n/a | 16.35K | - | 1 | - | |
| Index range scan [joinit.PRIMARY] REMOVED | 11.06 ms | n/a | 16.35K | - | 1 | - | |
| Inner hash join (orders.user_id = users.id) NEW | n/a | 1.90 ms | - | 12.00K | - | 1 | |
| Table scan [users] NEW | n/a | 2.54 ms | - | 3.00K | - | 1 | |
| Table scan [orders] NEW | n/a | 3.81 ms | - | 12.00K | - | 1 |