Patent ID: 11868352
Assignee: SNOWFLAKE INC.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 12:
13. A non-transitory machine-readable medium storing instructions which, when executed by one or more processors of a processing device, cause the one or more processors to:
determine an amount of available space in a first memory used by a set of relational queries is insufficient for a query, wherein the query comprises a join operation;
identify a first partition of a set of partitions based on a set of probe memory sizes and a set of build memory sizes, wherein to identify the first partition is further to identify a subset of the set of partitions based on the set of build memory sizes and a threshold memory size, wherein the first partition possesses:
a smallest available probe memory size of the set of partitions; and
a build memory size greater than or equal to the threshold memory size, wherein the threshold memory size is a percentage of a maximum build memory size and an average of the build memory sizes of the set of partitions, wherein the largest partition of the set of partitions has the maximum build memory size; and

copy the first partition from the first memory to a second memory.