On 9/5/2012 4:11 PM, E. Timothy Uy wrote:
Are you saying that
UPDATE alpha SET frequency = (SELECT frequency FROM beta WHERE beta.term
= alpha.term)
is just as efficient as it gets and equivalent to an update using join (in
other dbs)?
I don't know what other DBMS are doing. In SQLite, this update statement
would have a query plan very similar to the one for
select alpha.frequency, beta.frequency from alpha, beta
where beta.term = alpha.term;
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
