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

Claim 2:
3. The system of claim 1, wherein the operations further comprise:
receiving a second query plan, the second query plan including a particular set of statements, the particular set of statements including at least one particular statement with at least a particular reference to a first particular column in a first particular table and a second particular column in a second particular table;
identifying a first particular predicate from the at least one particular statement, the first particular predicate corresponding to a particular join operation;
determining, for the first particular column, a particular set of expression properties;
based on the particular set of expression properties, determining a first particular derived predicate, the first particular derived predicate indicating that a set of values from the first particular column are not null;
generating a particular new operation based on the first particular derived predicate, the particular new operation comprising a filter operation for filtering null values from the set of values from the first particular column; and
generating a particular new query plan based at least in part on the particular join operation of first particular predicate, the first particular derived predicate, and the particular new operation of the first particular derived predicate.