Patent Document ID: 10152509
Application ID: 14863425

Base Claim:
1. A computer-implemented method for query hint learning in a database management system, the method comprising: detecting, by the database management system, a hint in a first query, wherein the first query has a first signature, and wherein the hint includes statistics associated with a table in a database management system; receiving, by the database management system, a second query having a second signature, wherein the second query is received at a later time relative to the first query; determining, by the database management system, that the second signature correlates with the first signature; establishing, by the database management system, a query plan for executing the second query utilizing the hint in the first query, wherein establishing the query plan for executing the second query includes using a machine-learning technique to learn from the first query and the hint in the first query and creating a third query 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 for executing the second query.

---

Claim 5:
5. The method of claim 1 , wherein the second signature matches the first signature, and further comprising: monitoring, by the database management system in response to detecting the hint in the first query, an incoming query to determine whether an incoming signature of the incoming query matches the first signature, wherein the incoming query includes the second query.