发明授权
US6144957A Method and apparatus for using incompatible types of indexes to process
a single query
有权
使用不兼容类型的索引来处理单个查询的方法和设备
- 专利标题: Method and apparatus for using incompatible types of indexes to process a single query
- 专利标题(中): 使用不兼容类型的索引来处理单个查询的方法和设备
-
申请号: US311181申请日: 1999-05-13
-
公开(公告)号: US6144957A公开(公告)日: 2000-11-07
- 发明人: Jeffrey Ira Cohen , Cetin Ozbutun , Hakan Jakobsson , Michael Depledge
- 申请人: Jeffrey Ira Cohen , Cetin Ozbutun , Hakan Jakobsson , Michael Depledge
- 申请人地址: CA Redwood Shores
- 专利权人: Oracle Corporation
- 当前专利权人: Oracle Corporation
- 当前专利权人地址: CA Redwood Shores
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
A method and apparatus for processing a query combines the use of different index types to minimize the rows of data that need to be retrieved from a table. A first index is accessed based on a query to produce a first result having a first format, for example a bitmap index outputting a bitmap. A second index, for example a B-tree index, is also accessed based on the query to produce a second result having a second format, for example a sequence of rowids. The first result is converted to a converted result having the second format, and the converted result and the second result are combined to obtain an end result. The end result can then be used to locate data that satisfies the query while minimizing the rows of data that need to be retrieved from a table during the query processing.
公开/授权文献
- US5457127A Fungicidal mixtures 公开/授权日:1995-10-10
信息查询