Query Plan Comparison

Before vs After — generated by myflames

13.68 ms

Before

8.25 ms

After

↓-39.7%

Change

2 / 3

Operators (before / after)

What changed

✓ Query got faster: 13.68 ms → 8.25 ms (↓-39.7%)
✗ New full scan: orders
✗ New full scan: users
✗ New warning: 1 hash join(s) — uses join_buffer_size (~12000 rows in build phase)
✗ New warning: Full table scan: users (3000 rows), orders (12000 rows)

Operator comparison

Operator	Self-time (before)	Self-time (after)	Rows (before)	Rows (after)	Loops (before)	Loops (after)	Delta
Filter: ((joinit.i > 50)) REMOVED	2.62 ms	-	16.35K	-	1	-
Index range scan [joinit.PRIMARY] REMOVED	11.06 ms	-	16.35K	-	1	-
Inner hash join (orders.user_id = users.id) NEW	-	1.90 ms	-	12.00K	-	1
Table scan [users] NEW	-	2.54 ms	-	3.00K	-	1
Table scan [orders] NEW	-	3.81 ms	-	12.00K	-	1