On Thu, Jun 26, 2014 at 11:41 AM, Eleytherios Stamatogiannakis < [email protected]> wrote:
> Hi, > > I've seen that SQLite supports the "SorterOpen" Op, to do merge sorting. > So based on that, does SQLite support merge joins when both inputs of the > join are sorted? > No, not at this time. Note that a merge-join is more complicated than it appears at first glance for the common case where the join key is not unique in one or the other of the two tables being joined. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
