Estimated execution time for query execution

A method comprising:

• tracking a plurality of queries corresponding to a plurality of query plans based on join operations contained in each of the plurality of queries and a previous time of executing each query from the plurality of query plans, the join operations contained in each of the plurality of queries resulting in a table size larger than a particular number of rows and the previous time of executing each query falling within a particular period of time;
• selecting a first query plan among the plurality of query plans;
• determining a value indicating an estimated improvement in execution time of the first query plan in comparison to a previous execution time of a previous query plan;
• in response to determining that the value is greater than a threshold value, attempting to execute a first query using the first query plan, the attempting comprising:
• determining that a second query plan selected among the plurality of query plans has a second estimated execution time that is less than an estimated execution time of the first query plan;
• and
• executing the first query corresponding to the first query plan at a subsequent time using the second query plan, the executing the second query plan facilitating a decrease in execution time of the first query compared to using the first query plan.

A non-transitory computer-storage medium comprising instructions that, when executed by one or more processors of a machine, configure the machine to perform operations comprising:

• tracking a plurality of queries corresponding to a plurality of query plans based on join operations contained in each of the plurality of queries and a previous time of executing each query from the plurality of query plans, the join operations contained in each of the plurality of queries resulting in a table size larger than a particular number of rows and the previous time of executing each query falling within a particular period of time;
• selecting a first query plan among the plurality of query plans;
• determining a value indicating an estimated improvement in execution time of the first query plan in comparison to a previous execution time of a previous query plan;
• in response to determining that the value is greater than a threshold value, attempting to execute a first query using the first query plan, the attempting comprising:
• determining that a second query plan selected among the plurality of query plans has a second estimated execution time that is less than an estimated execution time of the first query plan;
• and
• executing the first query corresponding to the first query plan at a subsequent time using the second query plan, the executing the second query plan facilitating a decrease in execution time of the first query compared to using the first query plan.