发明名称 |
Apparatus and method for optimizing a query to a partitioned database table using a virtual maintained temporary index that spans multiple database partitions |
摘要 |
A query optimizer optimizes a query to a partitioned database table by determining common characteristics of the partitions and generating a virtual maintained temporary index that spans multiple partitions. Using the virtual maintained temporary index allows the query optimizer to generate an access plan based on the virtual maintained temporary index, which relieves the optimizer from having to individually optimize access to each partition for partitions that share common characteristics.
|
申请公布号 |
US2007226176(A1) |
申请公布日期 |
2007.09.27 |
申请号 |
US20060388004 |
申请日期 |
2006.03.23 |
申请人 |
INTERNATIONAL BUSINESS MACHINES CORPORATION |
发明人 |
BESTGEN ROBERT J.;DOWNER ROBERT V.;KETHIREDDY SHANTAN |
分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|