Hi, I need to join 2 tables A and B on 3 columns, ie.
"select A.4, B5 where A1 = B1 and A2 = B2 and A3 = B3" the columns B1, B2, B3 are individually indexed, I also have an index of (B1,B2,B3). A has about 23000 rows and B about 17000. The query is very slow, I don't understand why, can someone please tell me where my mistake is? Günther _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
