Thanks for the suggestion.
Changing the USING to ON makes absolutely no difference. The speed is
the same and the query plans (both EXPLAIN and EXPLAIN QUERY PLAN) are
absolutely identical. Same for if I convert it to WHERE:
WHERE joining_table.data_id = data_table.data_id;
On 2019-12-03 14:46, Simon Slavin wrote:
On 3 Dec 2019, at 8:48am, Jonathan Moules <jonathan-li...@lightpear.com> wrote:
SELECT
count(1)
FROM
data_table
JOIN joining_table USING (data_id);
SELECT
count(1)
FROM data_table
JOIN joining_table
ON joining_table.data_id = data_table.data_id;
Given the rest of the structure you gave, including the indexes, compare the
speeds of these two.
Simon
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
