Patent ID: 7987164
Filing Date: 2011-07-26
Classification: G06F

Abstract:
1. A method of maintaining an index of a partitioned database table stored in a memory of a computer system comprising, a processor and the memory, the method comprising: performing a partition maintenance operation on the partitioned database table stored in the memory using at least one table partition maintenance data definition language statement, wherein the partitioned database table has a user-defined index, and wherein a plurality of rows of the partitioned database table are moved from one partition of the database table to another partition of the database table; during the partition maintenance operation, storing mapping information in the memory for at least some of the plurality of moved rows, the stored mapping information comprising an old row identifier of a location of a row before the row was moved for each one of the at least some of the plurality of moved rows and a new row identifier of a location of the row after the row was moved for each one of the at least some of the plurality of moved rows along with a mapping indicating the correspondence between each old row identifier and each new row identifier, wherein the stored mapping information is stored in a global temporary table stored in the memory; and when rebuilding the index, replacing an old row identifier in the index for each one of the at least some of the plurality of moved rows with the corresponding stored new row identifier for each one of the at least some of the plurality of moved rows instead of rebuilding the index from scratch, wherein at least some of the original structures of the index are reused for rebuilding the index; wherein the partition maintenance operation is performed by a plurality of processes in parallel and the stored mapping information is shared among the plurality of processes using the global temporary table.