On 1 Jun 2009, at 11:32am, Ralf wrote: > [>> ] considering a m:n relation a.id <- a.id,b.id -> b.id, is it > due to > performance, advisable to put an index on a.id,b.id ?
Index both fields in your 'middle' file individually unless you expect it to stay very small. The 'id' fields in your outer two files will, of course, already be indexed because they are each file's primary index and must be unique. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
