Are there any plans to implement merge joins in sqlite? As far as I am aware,
only nested loops are currently supported.
Merge joins could be an incredible optimization in some cases for large queries
and would make sqlite much faster in such cases.
Personally, I would like to have this option
> You are thinking that perhaps queries such as the following might
> be faster using a merge:
>
> SELECT * FROM tab1 JOIN tab2 ON tab1.a=tab2.x;
>
> I disagree.
I don't see any reason to disagree. Merge join will definitely be faster if the
data is already sorted. See the reference:
ht
2 matches
Mail list logo