Claims
- 1. A method for creating execution plans, the method comprising the steps of:
receiving a database command that contains a predicate based on an IN operator; wherein said database command references a table that is partitioned into a plurality of partitions based on a partition key; wherein a first argument of said IN operator is based on a multi-column in-list; wherein a second argument of said IN operator references the partition key; and determining an execution plan based on said database command, said execution plan including a first plan operator, said first plan operator specifying operations that limit scanning to partitions having rows containing a partition key value in said multi-column in-list.
- 2. The method of claim 1, wherein said second argument references another column in addition to said partition key.
- 3. The method of claim 1, wherein said table is partitioned based on another key.
- 4. A computer-readable medium carrying one or more sequences of instructions for creating execution plans, wherein execution of the one or more sequences of instructions by one or more processors causes the one or more processors to perform the steps of:
receiving a database command that contains a predicate based on an IN operator; wherein said database command references a table that is partitioned into a plurality of partitions based on a partition key; wherein a first argument of said IN operator is based on a multi-column in-list; wherein a second argument of said IN operator references the partition key; and determining an execution plan based on said database command, said execution plan including a first plan operator, said first plan operator specifying operations that limit scanning to partitions having rows containing a partition key value in said multi-column in-list.
- 5. The computer-readable medium of claim 4, wherein said second argument references another column in addition to said partition key.
- 6. The computer-readable medium of claim 4, wherein said table is partitioned based on another key.
RELATED APPLICATION
[0001] This application claims priority to and is a divisional of U.S. application Ser. No. 10/118,762, entitled “Efficient Processing of Multi-Column And Function Based In-List Predicates”, filed by Dinesh Das on Apr. 8, 2002, the contents of which are hereby incorporated by reference.
Divisions (1)
|
Number |
Date |
Country |
Parent |
10118762 |
Apr 2002 |
US |
Child |
10880633 |
Jun 2004 |
US |