Dynamically substituting a modified query based on performance analysis

Abstract

The disclosure herein describes analyzing queries and dynamically modifying those queries based on the analysis. An indication that a query is to be executed by a first process is detected. It is determined that an analysis results data store does not include an active analysis result for the query using a query identifier of the query and, as a result, a modified instance of the query is generated using a modification pattern. The query and the modified instance of the query are analyzed based on a performance metric using a second process that is independent of the first process. An active analysis result of the query is recorded based on the analysis, wherein the analysis result indicates whether future executions of the query should be modified using the modification pattern. Further, in some examples, analysis results expire, such that associated queries are reanalyzed to generate active analysis results periodically.