发明名称 |
Efficient processing of multi-column and function-based in-list predicates |
摘要 |
Described herein are approaches for generating execution plans for database commands that include an in-list predicate. The approaches can be used to generate execution plans that exploit the power of in-list iterators in ways and under circumstances not previously supported by conventional DBMSs. An in-list iterator may be used with execution subplans for processing multi-column in-list queries. An in-list iterator is used with execution subplans that scan function-based indexes. The execution plans for a multi-column in-list query limit table scans to only table partitions that contain data that satisfy the query.
|
申请公布号 |
US7213011(B1) |
申请公布日期 |
2007.05.01 |
申请号 |
US20020118762 |
申请日期 |
2002.04.08 |
申请人 |
ORACLE INTERNATIONAL CORPORATION |
发明人 |
DAS DINESH |
分类号 |
G06F17/30;G06F17/00 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|