Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm #7116
| Job | Run time |
|---|---|
| 14m 48s | |
| 12m 3s | |
| 8m 3s | |
| 1m 28s | |
| 10m 48s | |
| 22m 32s | |
| 8m 45s | |
| 23m 9s | |
| 10m 44s | |
| 8m 20s | |
| 11m 7s | |
| 5m 11s | |
| 8m 53s | |
| 10m 49s | |
| 8m 25s | |
| 9m 52s | |
| 46m 3s | |
| 33m 26s | |
| 10m 41s | |
| 3m 33s | |
| 3m 47s | |
| 3m 15s | |
| 3m 28s | |
| 2m 14s | |
| 4h 41m 24s |