发明授权
- 专利标题: Hybrid optimization strategies in automatic SQL tuning
- 专利标题(中): 自动SQL调优中的混合优化策略
-
申请号: US12221131申请日: 2008-07-30
-
公开(公告)号: US07979422B2公开(公告)日: 2011-07-12
- 发明人: Peter Belknap , Khaled Yagoub , Karl Dias , Benoit Dageville , Thierry Cruanes , Anupam Singh
- 申请人: Peter Belknap , Khaled Yagoub , Karl Dias , Benoit Dageville , Thierry Cruanes , Anupam Singh
- 申请人地址: US CA Redwood Shores
- 专利权人: Oracle International Corp.
- 当前专利权人: Oracle International Corp.
- 当前专利权人地址: US CA Redwood Shores
- 代理机构: Kraguljac & Kalnay, LLC
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
Systems, methods, and other embodiments associated with hybrid optimization strategies in automatic SQL tuning are described. One example method includes receiving a first (e.g., cost-based) execution plan for a user structured query language statement (User SQL) from a first (e.g., cost-based) optimizer. The example method may also include receiving a second (e.g., rules-based) execution plan for the User SQL from a second, different (e.g., rules-based) query optimizer. The method may include identifying a preferred execution plan based on data produced by test executing the execution plans in a reproduced execution environment that reproduces at least a portion of an execution environment in which the user SQL runs. The method may also include controlling a database to execute the User SQL using the preferred execution plan.
公开/授权文献
- US20100030758A1 Hybrid optimization strategies in automatic SQL tuning 公开/授权日:2010-02-04
信息查询