发明申请
- 专利标题: Displaying explain data for a SQL query of a database
- 专利标题(中): 显示数据库的SQL查询的说明数据
-
申请号: US10977801申请日: 2004-10-29
-
公开(公告)号: US20060095406A1公开(公告)日: 2006-05-04
- 发明人: Robert Bestgen , Shantan Kethireddy , Michael Pfeifer
- 申请人: Robert Bestgen , Shantan Kethireddy , Michael Pfeifer
- 申请人地址: US NY ARMONK
- 专利权人: INTERNATIONAL BUSINESS MACHINES CORPORATION
- 当前专利权人: INTERNATIONAL BUSINESS MACHINES CORPORATION
- 当前专利权人地址: US NY ARMONK
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
Enabling a user to obtain and view graphic explain data with no need to activate a monitor and no need to wait for a job to complete before the explain data for a query may be viewed. Displaying explain data for an SQL query of a database that include executing an SQL query and displaying explain data for the SQL query while executing the SQL query. Displaying explain data includes identifying an access plan associated with the SQL query and generating explain data in dependence upon the access plan. Identifying an access plan may be carried out by retrieving an access plan identification from a cursor of a job control block and retrieving an access plan from an access plan cache in dependence upon the access plan identification.
信息查询