Invention Grant
US07987164B2 Method and system for speeding up rebuild of user-defined indexes during partition maintenance operations in the database systems 有权
在数据库系统中的分区维护操作期间加快重建用户定义索引的方法和系统

Method and system for speeding up rebuild of user-defined indexes during partition maintenance operations in the database systems
Abstract:
A method, system, and computer program product provides improved performance for rebuild of user-defined indexes during partition maintenance operations (partition split, merge, and move). A method of maintaining a index of a partitioned database table comprises performing a partition maintenance operation on the partitioned database table wherein a plurality of rows of the partitioned database table are moved from one partition to another, storing mapping information for at least some of the plurality of moved rows, including an old mapping for each of the moved rows and a corresponding new mapping for each of the moved rows, and when rebuilding the index, replacing an old mapping in the index for each of the plurality of moved rows with the corresponding stored new mapping for each of the plurality of moved rows.
Information query
Patent Agency Ranking
0/0