EXTERNAL OFFLINE QUERY OPTIMIZATION

摘要

A determination is made that an execution plan for a received structure query language (SQL) database query to execute on a database is not present in a database plan cache. An external offline optimization process is triggered to generate an externally optimized execution plan for the SQL database query. The generation of the externally optimized execution plan includes: receiving all or part of the received SQL database query as SQL statements and metadata associated with the database, looping over and analyzing all the received SQL statements, selecting at least one an optimization strategy for the SQL statements; and executing the selected at least one optimization strategy to generate the externally optimized execution plan. The externally optimized execution plan is then pinned into the database plan cache.

主权项

1. A computer-implemented method, comprising:
determining that an execution plan for a received structure query language (SQL) database query to execute on a database is not present in a database plan cache; triggering an external offline optimization process to generate an externally optimized execution plan for the SQL database query, the generation including:
receiving all or part of the received SQL database query as SQL statements and metadata associated with the database;looping over and analyzing all the received SQL statements;selecting at least one an optimization strategy for the SQL statements; andexecuting the selected at least one optimization strategy to generate the externally optimized execution plan; and pinning the externally optimized execution plan into the database plan cache.