|
|
|
|
|
|
by cryptonector
1463 days ago
|
|
|
A naive FULL OUTER JOIN is O(N), which is not efficient, indeed. An RDBMS could implement something like the rsync algorithm, or history tables, etc., to speed up a FULL OUTER JOIN. The point is that FULL OUTER JOIN is the SQL table source "diff" primitive. Thus it seems natural to use that and let the RDBMS optimize it. |
|
|