On Wed, Jan 23, 2013 at 02:12:39PM +0100, Krzysztof scratched on the wall: > Hi, > > I'm reading http://www.sqlite.org/foreignkeys.html but can't find answer. > Are SQLite FK indexed? For example:
Not automatically. From that page: 3. Required and Suggested Database Indexes [...] Indices are not required for child key columns but they are almost always beneficial. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users