Generating an optimized join tree for execution of a plurality of join operations via a database system

A query and response sub-system of a database system comprises:

• a plurality of computing device clusters, wherein a computing device cluster of the plurality of computing device clusters includes a plurality of computing devices, wherein a computing device of the plurality of computing devices includes a plurality of computing nodes, wherein a computing node of the plurality of computing nodes includes a plurality of processing core resources, wherein a set of processing core resources of the pluralities of processing core resources is operable to optimize memory usage during query execution by:
• obtaining an initial query that includes a plurality of join operations involving a plurality of tables, wherein the plurality of join operations has an initial organizational structure of execution;
• determining a plurality of cardinality values for the plurality of tables, wherein a first cardinality value of the plurality of cardinality values is regarding a first number of rows of a first table of the plurality of tables to be included in a join operation of the plurality of join operations;
• determining an initial cumulative cardinality value for the initial organizational structure of execution of the plurality of join operations based on the plurality of cardinality values;
• when the initial cumulative cardinality value compares favorably to an output cardinality threshold:
• utilizing the initial organizational structure of execution in an optimized query plan;
• and
• when the initial cumulative cardinality value compares unfavorably to the output cardinality threshold:
• utilizing an optimized organizational structure of execution of the plurality of join operations in the optimized query plan.