发明授权
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
摘要:
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.
公开/授权文献
信息查询
0/0