Patent ID: 7617265

Claim:
A management method for a plurality of indexes, in a database management system includes servers and a storage apparatus, comprising the steps of: storing a table into a table area in the storage apparatus; storing a first index associated with the table into a first index area in the storage apparatus; assigning, to one of the servers, a partition table area corresponding to a partition of the table and a partition index area corresponding to a partition of the first index; creating a second index related to the assigned partition index area for each server; if the second index is not created then the partition index area in the storage apparatus from the server is accessed for accessing the table; if the second index is created and stored in the server, the second index is accessed for accessing the table; if configuration alteration to the one server occurs, the assigned server invalidates the second index, uses the first index for accessing the table and creates in the background a new second index table, after the configuration alteration has occurred the assigned sewer validates the new second index for accessing the table.