Crate Version: 4.3.2
We have 2 tables
Table_A consists of 40k records and
Table_B consists of 400k records. Whenever we apply
left join the crate DB kind of hangs and results coming in 140 secs… that’s too slow.
Note: I noticed that in left/right join nestableloop is getting applied instead of hash joins. Is there a way we can apply hash joins in left/right join cases?
Also Is there any other way we can achieve the same behaviour like left joins but which can respond quickly.
Any help would be much appreciated. @jayeff