Lateral join joins a subquery, which is executed as many times as there are rows in the leading table. Consider it as a kind of for-each loop. Most of, if not all, the problems it solves, can also be solved without lateral join (e.g. using analytic f...
Oracle DBA
DBA Team Lead and Oracle ACE Pro. Building database tools and helping teams manage Oracle infrastructure.
Markdown supported · ⌘↵ to post
No responses yet.