1. A computer implemented method, comprising: transforming a base query to generate a transformed query; wherein the base query includes a union between each base branch of a plurality of base branches; wherein each of two or more base branches of said plurality of base branches joins a set of tables; wherein the sets of tables of the two or more base branches of the plurality of base branches include a common table set shared by all the sets of tables, said common table set including a common table; wherein each of the two or more base branches of the plurality of base branches include a respective set of tables that does not include said common table set; wherein the step of transforming the base query includes replacing the plurality of base branches with a first group branch that joins the common table and an inline view, the inline view comprising a union between a plurality of respective branches, wherein the plurality of respective branches includes, for each base branch of said plurality of base branches, a FROM list that: references the respective set of tables, and does not reference the common table; and wherein the method is performed by one or more computing devices.
1. A computer implemented method, comprising: transforming a base query to generate a transformed query; wherein the base query includes a union between each base branch of a plurality of base branches; wherein each of two or more base branches of said plurality of base branches joins a set of tables; wherein the sets of tables of the two or more base branches of the plurality of base branches include a common table set shared by all the sets of tables, said common table set including a common table; wherein each of the two or more base branches of the plurality of base branches include a respective set of tables that does not include said common table set; wherein the step of transforming the base query includes replacing the plurality of base branches with a first group branch that joins the common table and an inline view, the inline view comprising a union between a plurality of respective branches, wherein the plurality of respective branches includes, for each base branch of said plurality of base branches, a FROM list that: references the respective set of tables, and does not reference the common table; and wherein the method is performed by one or more computing devices. 2. The method of claim 1 , wherein each base branch of said plurality of base branches includes a respective join condition based on a particular column of said common table and a particular join condition operator; wherein the first group branch includes a join condition based on the join condition operator, a column of the inline view, and the column of the common table; and wherein each branch of said plurality of respective branches excludes the respective join condition.