Invention Grant
- Patent Title: Query hint learning in a database management system
-
Application No.: US15075177Application Date: 2016-03-20
-
Publication No.: US10152510B2Publication Date: 2018-12-11
- Inventor: Shawn J. Baranczyk , Rafal P. Konik , Roger A. Mittelstadt , Brian R. Muras
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Daniel R. Simek
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F17/27 ; G06N99/00

Abstract:
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.
Public/Granted literature
- US20170083828A1 QUERY HINT LEARNING IN A DATABASE MANAGEMENT SYSTEM Public/Granted day:2017-03-23
Information query