发明授权
- 专利标题: Function-based index tuning for queries with expressions
- 专利标题(中): 具有表达式的查询的基于函数的索引调整
-
申请号: US11287622申请日: 2005-11-28
-
公开(公告)号: US07634457B2公开(公告)日: 2009-12-15
- 发明人: Shilpa S. Lawande
- 申请人: Shilpa S. Lawande
- 申请人地址: US CA Redwood Shores
- 专利权人: Oracle International Corp.
- 当前专利权人: Oracle International Corp.
- 当前专利权人地址: US CA Redwood Shores
- 代理机构: Kraguljac & Kalnay, LLC
- 主分类号: G06F7/00
- IPC分类号: G06F7/00 ; G06F17/30
摘要:
Systems, methods, and media associated with function-based index tuning for queries with expressions are described. One exemplary method includes receiving a query for which an index is to be recommended. The query may include an expression, thus the method may include identifying an expression in the query and generating a set of column statistics related to the expression. The method may also include identifying candidate function-based indexes associated with the query, generating a set of function-based index statistics related to the candidate function-based indexes, and recommending a candidate function-based index.
公开/授权文献
- US20070083483A1 Function-based index tuning for queries with expressions 公开/授权日:2007-04-12
信息查询