Does a foreign key field need a separate index?

Rael Bauer <support-/[email protected]> Thu, 6 Feb 2020 23:23:36 +0200

Newsgroups	gmane.comp.db.sqlite.general
Message-ID	<[email protected]>

Hi,

Is a foreign key field automatically indexed, or will it benefit from a 
separately created index?

E.g.

CREATE TABLE [content](
   [note_id] INTEGER REFERENCES [notes]([id]) ON DELETE CASCADE,
   [data] BLOB);

Will note_id benefit from a separately created index?

Thanks
Rael

_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users