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
