Transient materialized view rewrite

A machine-storage medium embodying instructions that, when executed by a machine, cause the machine to perform operations comprising:

• receiving, by a processor, a query directed to a source table, the source table including a plurality of micro-partitions;
• generating a query plan to execute the query, the query plan including a plurality of operators;
• determining a first micro-partition of the plurality of micro-partitions to be pertinent to the query and determining a second micro-partition of the plurality of micro-partitions to be non-pertinent to the query;
• revising the query plan based on the first and second micro-partitions;
• rewriting the query plan to generate a rewritten query plan using a materialized view including data from the first and second micro-partitions and the rewritten query plan includes adding a new filtering operator not in the query plan taking into account the materialized view including data from the second micro-partition;
• and
• executing the rewritten query plan.

A system comprising:

• one or more processors of a machine;
• and
• a memory storing instructions that, when executed by the one or more processors, cause the machine to perform operations comprising:
• receiving a query directed to a source table, the source table including a plurality of micro-partitions;
• generating a query plan to execute the query, the query plan including a plurality of operators;
• determining a first micro-partition of the plurality of micro-partitions to be pertinent to the query and determining a second micro-partition of the plurality of micro-partitions to be non-pertinent to the query;
• revising the query plan based on the first and second micro-partitions;
• rewriting the query plan to generate a rewritten query plan using a materialized view including data from the first and second micro-partitions and the rewritten query plan includes adding a new filtering operator not in the query plan taking into account the materialized view including data from the second micro-partition;
• and
• executing the rewritten query plan.