Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm

FirebirdSQL / firebird

Firebird server, client and tools

https://www.firebirdsql.org/

1.19k stars 204 forks source link

Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm #8061

Open dyemanov opened 1 month ago

dyemanov commented 1 month ago

The initial implementation was developed by customer request, later it was slightly improved and committed into a separate branch for testing. Some issues were found that prevented it from inclusion into v5.0. Still work in progress.