Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm #6652
| Job | Run time |
|---|---|
| 7m 48s | |
| 1m 24s | |
| 14m 6s | |
| 11m 9s | |
| 9m 28s | |
| 10m 26s | |
| 8m 10s | |
| 19m 52s | |
| 8m 44s | |
| 8m 14s | |
| 9m 29s | |
| 21m 0s | |
| 5m 1s | |
| 10m 3s | |
| 8m 50s | |
| 10m 5s | |
| 46m 31s | |
| 8m 10s | |
| 34m 46s | |
| 3m 35s | |
| 3m 28s | |
| 3m 18s | |
| 4m 1s | |
| 1m 39s | |
| 4h 29m 17s |