Invention Grant
US08825629B2 Method for index tuning of a SQL statement, and index merging for a multi-statement SQL workload, using a cost-based relational query optimizer
有权
使用基于成本的关系查询优化器对SQL语句进行索引调整的方法以及多语句SQL工作负载的索引合并
- Patent Title: Method for index tuning of a SQL statement, and index merging for a multi-statement SQL workload, using a cost-based relational query optimizer
- Patent Title (中): 使用基于成本的关系查询优化器对SQL语句进行索引调整的方法以及多语句SQL工作负载的索引合并
-
Application No.: US10936469Application Date: 2004-09-07
-
Publication No.: US08825629B2Publication Date: 2014-09-02
- Inventor: Shilpa Lawande , Mohamed Ziauddin , Gregory Scott Smith
- Applicant: Shilpa Lawande , Mohamed Ziauddin , Gregory Scott Smith
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Vista IP Law Group, LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
An access structure analysis method is interspersed with the query optimization process. The method can determine the ideal combination of access structures, including both materialized views and indexes, for a given database workload. The interspersed structure analysis method can include advanced transformations like view merging, star transformation, bitmap access plans, query rewrite using materialized views, for example. The method may be performed using the query optimizer's rules as heuristics to guide the index candidate generation process.
Public/Granted literature
Information query