Hi Pavel, yes - you are quite right, I wasn't precise here! Sorry about that! What I meant was a join on unit_id, which obviously will have an index if that's needed.
Thanks for your help! Kind regards Stefan Btw., in the same context, I noticed that sparse data of the database (with lots of NULL values), which would otherwise bloat the database doesn't seem to be a problem in SQLite with it's type affinity scheme! Nice! -- View this message in context: http://old.nabble.com/Limitation-on-Column-count-tp27117364p27231605.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
