Looking for opinions on the relative efiiciency of Scalar queries versus
non-scalar with JOIN statements.

For example, the following two queries would produce the same results but
would one of them be significantly faster than the other?

SELECT column1, tableB.column2 FROM TableA LEFT JOIN TableB ON
TablebB.indexcolumn = TableA.primarykeycolumn

OR

SELECT column1, (SELECT column2 FROM TableB WHERE TableB.indexcolumn =
TableA.primarykeycolumn) FROM TableA

Thanks,

Pete
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to