发明申请
- 专利标题: Caching an Access Plan for a Query
- 专利标题(中): 缓存查询访问计划
-
申请号: US11627672申请日: 2007-01-26
-
公开(公告)号: US20080183684A1公开(公告)日: 2008-07-31
- 发明人: Robert J. Bestgen , Michael S. Faunce , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
- 申请人: Robert J. Bestgen , Michael S. Faunce , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
Methods, apparatus, and products are disclosed for caching an access plan for a query that include: receiving, in a SQL module of a DBMS, a SQL query that specifies data for retrieval from a database, the database characterized by database statistics, the SQL query characterized by one or more host variable values; generating, by the SQL module, an access plan in dependence upon the SQL query; calculating, by the SQL module, a routing code for the SQL query in dependence upon the host variable values of the SQL query and a portion of the database statistics; and storing, by the SQL module, the access plan in an access plan cache, including associating with the access plan the routing code for the SQL query and the portion of the database statistics used to calculate the routing code.
信息查询