QUERY HINT LEARNING IN A DATABASE MANAGEMENT SYSTEM

摘要

Disclosed aspects relate to query hint learning in a database management system. A hint in a first query is detected by the database management system. The first query has a first signature. A second query is received by the database management system. The second query has a second signature. A determination is made by the database management system that the second signature correlates with the first signature. A query plan is established by the database management system. The query plan is based on the second query and uses the hint in the first query. In response to receiving the second query, the database management system processes the query plan.

主权项

1. A system for query hint learning in a database management system, the system comprising:
a memory having a set of computer readable computer instructions, and a processor for executing the set of computer readable instructions, the set of computer readable instructions including: detecting, by the database management system, a hint in a first query, wherein the first query has a first signature; receiving, by the database management system, a second query having a second signature; determining, by the database management system, that the second signature correlates with the first signature; establishing, by the database management system, a query plan which is based on the second query and uses the hint in the first query; and processing, by the database management system in response to receiving the second query, the query plan.