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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users