Query plan sharing

A system comprising:

• at least one processor;
• and
• a non-transitory machine-readable medium storing instructions that, when executed by the at least one processor, cause the at least one processor to perform operations comprising:
• executing a first query using a first query execution plan and generating a first result data by applying a first query operator to a first data stored in a first storage location;
• providing the first result data to a second query execution plan for execution of a second query;
• executing the second query on a second data stored in a second storage location in accordance with the second query execution plan, the second query execution plan including a second query operator being applied to the second data to generate second query intermediate result data, the second query being separate from the first query, and the second storage location being separate from the first storage location;
• preventing application of the second query operator to the provided first result data upon determination that the second query operator is not applicable to the provided first result data;
• and
• generating, based on the execution of the second query, a second result data in accordance with the second query execution plan and by applying another second query operator of the second query to a combination of the second query intermediate result data and the provided first result data.

A computer program product comprising a non-transitory machine-readable medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations comprising:

• executing a first query using a first query execution plan and generating a first result data by applying a first query operator to a first data stored in a first storage location;
• providing the first result data to a second query execution plan for execution of a second query;
• executing the second query on a second data stored in a second storage location in accordance with the second query execution plan, the second query execution plan including a second query operator being applied to the second data to generate second query intermediate result data, the second query being separate from the first query, and the second storage location being separate from the first storage location;
• preventing application of the second query operator to the provided first result data upon determination that the second query operator is not applicable to the provided first result data;
• and
• generating, based on the execution of the second query, a second result data in accordance with the second query execution plan and by applying another second query operator of the second query to a combination of the second query intermediate result data and the provided first result data.