On Sat, 8 Nov 2008 12:33:28 +0700, Dan <[EMAIL PROTECTED]> wrote: >That is a subjective statement. It could be true if there are a >lot more rows in table 'Companies' than there are in 'Code' and there >is no index on Companies.
There are indeed a lot more rows in COMPANIES than in CODE, since CODE is just a foreign key in COMPANIES that indicates which field the company is in, as set by the Bureau of statistics. Thanks guys. I'll check the suggestions above and compare performance. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
