On Thu, Feb 6, 2020 at 11:08 PM Simon Slavin <slav...@bigfraud.org> wrote: > 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.
The shell's .expert command might recommend them. Not sure, haven't tried. But in general, yes, FKs should be indexed, if are are CASCADE'ing them. --DD https://sqlite.org/cli.html#expert _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
