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.

sqlite-users mailing list

Reply via email to