In Part 1 of this blog we looked at the different ways to create or convert to Partition by Growth (PBG) table spaces. In this part we will review the advantages and disadvantages of PBGs, when it might be appropriate to use them, and making changes to existing PBGs.
Have you heard about the Lateral join? In short - lateral join or lateral correlation is simply a reference in a nested table expression to a column of a table identified at the same level in the FROM clause. Learn the basics in this article.
There are tremendously powerful programming possibilities with SQL and many of these features are translatable across RDBMS’s with only a modest amount of effort. Utilizing these advanced SQL features can drastically reduce development time and improve performance, and so let's explore them!