Patent ID: 8533181
Filing Date: 2013-09-10
Classification: G06F

Abstract:
1. A computer-implemented method, comprising: receiving a query on a partitioned table, where the query includes a first query operation that will result in a first query plan that includes accessing local domain indexes associated with individual partitions in the table to identify table partitions having data that meets the query criteria; rewriting the query to replace the first query operation with a second query operation that will result in a second query plan that includes a table function for accessing a global domain index to create a table that includes entries corresponding to row identifiers that identify table partitions having data that meets the query criteria instead of the local domain indexes associated with individual partitions of the tablet, where the table function includes a first operation that accesses a global domain index that indexes partition metadata on the table partitions to identify table partitions that meet the query criteria; and executing the rewritten query on the partitioned table to return records that match the query.