DYNAMIC DATABASE QUERY EFFICIENCY IMPROVEMENT

摘要

Examples of dynamic database query efficiency improvement are provided herein. Query portions of a received database query can be identified as candidates for replacement. The candidates for replacement can be query portions that reduce the efficiency of the query. Alternative queries can be determined that include substitute query portion(s) in place of candidate(s) for replacement. An expected performance of the alternative queries can be determined. Based at least in part on the expected performance of the alternative queries, one or more alternative queries can be selected as replacement database queries for the received database query.

主权项

1. One or more computer-readable storage media storing instructions that, when executed by a computing device, perform a method of improving efficiency of a database query, the method comprising:
receiving a database query; identifying one or more query portions of the database query as candidates for replacement; determining a plurality of alternative queries, the respective alternative queries including at least one substitute query portion in place of at least one of the candidates for replacement; determining an expected performance of at least some of the plurality of alternative queries; and based at least in part on the expected performance of the at least some of the plurality of alternative queries, selecting one or more alternative queries of the plurality of alternative queries as replacement database queries for the received database query.