Hi, I'm reading http://www.sqlite.org/foreignkeys.html but can't find answer. Are SQLite FK indexed? For example:
CREATE TABLE artists ( id_artist INTEGER PRIMARY KEY // <- PK are indexed, that I know ) CREATE TABLE songs ( id_song INTEGER PRIMARY KEY, id_artist INTEGER, // <- Is this FK indexed? FOREIGN KEY(id_artist) REFERENCES artists(id_artist) ) To be more specific: select * from songs where id_artist = 123 Is above query searching sequentially or using index? I'm asking because if I remember, FireBird FK where indexed by default, but Oracle needed create index on that FK manually. How this work in SQLite? Regards _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users