Patent Document ID: 10146819
Application ID: 14881211

Base Claim:
1. A method for database indexing of a database, a database index comprises at least one index include, the method comprising: obtaining the number of executions of each of a plurality of Structured Query Language (SQL) statements within a certain time period for the database, respectively, wherein the plurality of SQL statements use the database index; for each of the at least one index include: calculating a number of hits of the index include according to the number of executions of each of the plurality of SQL statements; obtaining a length of the index include; calculating a hit frequency of the index include by using the number of hits and the length of the index include, wherein: the hit frequency equals the number of hits divided by the length; reserving the index include according to a predetermined criterion, and wherein the reserving the index include according to the predetermined criterion comprises reserving the index include whose hit frequency is greater than a predetermined threshold; introducing into the database index, the reserved index include whose hit frequency is greater than the predetermined threshold; and performing an index re-org by using the reserved index include such that the reserve index include whose hit frequency is greater than the predetermined threshold is being introduced in the database index, resulting in improved query performance of the database index for optimizing database indexing, and thereby not requiring designation of index includes by a database administrator.

---

Claim 2:
2. The method according to claim 1 , wherein the reserving the index include according to a predetermined criterion comprises: arranging the at least one index include in a descending order according to the hit frequency; and reserving a predetermined number of index includes with a higher hit frequency.