Generation of query execution plans
AssigneeInternational Business Machines Corporation
InventorsShuo Li, Ke Wei Wei, Xin Ying Yang, Chen Xin Yu
Life of this patent
Estimating the term…
Loading patent…
AssigneeInternational Business Machines Corporation
InventorsShuo Li, Ke Wei Wei, Xin Ying Yang, Chen Xin Yu
Estimating the term…
Aspects of the present disclosure relate to an approach for generating query execution plans for a database query. A computer-implemented method comprises determining whether a size of a file to be generated during execution of a database query is variable in response to obtaining the database query. The method further comprises determining a plurality of ranges for the size of the file in response to determining that the size of the file is variable. The method further comprises generating a plurality of query execution plans corresponding to the plurality of ranges. Accordingly, a plurality of query execution plans corresponding to different file sizes can be generated for the database query, and an efficient and cost effective query execution plan may be selected based on the actual file size during the execution of the database query.
A device comprising:
A computer-implemented method comprising:
A computer program product being tangibly stored on a non-transient machine-readable medium and comprising machine-executable instructions, the instructions, when executed on a device, causing the device to:
Dependencies are inferred from the claim text.