- 专利标题: Provision of index recommendations for database access
-
申请号: US13251190申请日: 2011-09-30
-
公开(公告)号: US09773032B2公开(公告)日: 2017-09-26
- 发明人: Michael L. Perry
- 申请人: Michael L. Perry
- 申请人地址: US TX Houston
- 专利权人: BMC Software, Inc.
- 当前专利权人: BMC Software, Inc.
- 当前专利权人地址: US TX Houston
- 代理机构: Brake Hughes Bellermann LLP
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
A cost estimator may estimate execution costs for execution of at least one query against a database, using at least one existing index, if any, and based on estimation criteria determined from analyzing the query execution. A candidate index provider may provide candidate indexes, based on the estimation criteria, and re-estimate the execution costs to obtain updated execution costs, using the candidate indexes. An index recommender may recommend a recommended index, based on the updated execution costs.
公开/授权文献
- US20130086038A1 PROVISION OF INDEX RECOMMENDATIONS FOR DATABASE ACCESS 公开/授权日:2013-04-04