On 6 Feb 2020, at 9:23pm, Rael Bauer <supp...@bauerapps.com> wrote: > Is a foreign key field automatically indexed, or will it benefit from a > separately created index?
No indexes for either lookup are automatically created. You should create indexes which will help lookup in both directions, unless one of the tables is small or a useful index exists for some other reason, e.g. because the key is declared as UNIQUE. <https://sqlite.org/foreignkeys.html#fk_indexes> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users