Patent ID: 8595238
Filing Date: 2013-11-26
Classification: G06F

Abstract:
1. A method for forming an index to access a database table, the method comprising the steps of: a first server computer determining access performance and workload of at least some of a database, and in response, determining a recommendation for an index to a database table stored on the first server computer; the first server computer sending the recommendation for the index to a second server computer, wherein the second server computer maintains a previous version of the database table; the second server computer creating the recommended index using the previous version of the database table; the first server computer receiving the recommended index from the second server computer; the first server computer modifying the recommended index based on one or more differences between the database table stored on the first server computer and the previous version of the database table stored on the second server computer; and the first server computer subsequently using the index to access an entry in the database table.