On Thu, Feb 6, 2020 at 11:08 PM Simon Slavin <
[hidden email]> wrote:
> On 6 Feb 2020, at 9:23pm, Rael Bauer <
[hidden email]> 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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users