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 rather as a sql HINT, than as an 
optimizer option, since the optimizer now, small and efficient as it is, does a 
great job. The merge join HINT could be used to greatly optimize specific 
queries - i.e. queries where poking the index many many times on an already 
ordered set is inefficient.
sqlite-users mailing list

Reply via email to