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

Reply via email to