Extension of the join pushdown in MDEV-9062 we need a way to pushdown data from small tables in a join when pushdown join is used.
InnoDB table with 100 rows and 4 ColumnStore tables in a join. This feature should convert the 100 rows (or filtered results of the 100 rows) into something like an IN filter to pushdown the InnoDB results into ColumnStore.
Customers often use InnoDB tables as pivot tables in AX which have very small number of rows so this is a common use case.
There of course should be a threshold on this (a sysvar?), we don't know at what point this will become too expensive.
I'm guessing an optimizer flag will be needed to separate to pushdown join but only allowed to be turned on when pushdown join is turned on.