Asynchronous global index maintenance during partition maintenance

摘要

Techniques for maintaining a global index in response to a partition being dropped are provided. In response to an instruction to drop a partition, partition identification data that identifies the partition is stored. Index entries, in the global index, that correspond to the dropped partition become “orphaned” entries. Later, an execution plan for a query is processed, where the execution plan targets a global index. During execution of the execution plan, one or more index entries are accessed. For each accessed index entry, the partition identification data is analyzed to determine if the index entry is an orphaned entry. If so, then the index entry is ignored for purposes of the query. Later, the global index may be updated to delete each orphaned entry. Such deletion may occur much later, such as during a time when the database is not queried or updated frequently.

主权项

1. A method comprising:
receiving an instruction to drop a partition; in response to receiving the instruction, storing drop data that identifies the partition; receiving a query; in response to receiving the query:
traversing an index that comprises a plurality of index entries;wherein the plurality of index entries includes a first index entry that references a first row in the partition;wherein the plurality of index entries includes a second index entry that is different than the first index entry and that references a second row in the partition;wherein traversing the index comprises, for each index entry of two or more of the plurality of index entries:
determining, based on the drop data, whether said each index entry is associated with the partition,filtering out said each index entry if it is determined, based on the drop data, that said each index entry is associated with the partition; wherein the method is performed by one or more computing devices.