Patent Document ID: 9846713
Application ID: 15201653

Base Claim:
1. A method for index-only multi-index access in a relational database management system, comprising: determining that a query to be executed against a database requires multiple indexes; in determining that the query to be executed against the database requires the multiple indexes, determining whether one or more columns is needed for a query result, a subquery, or an inner join result; in determining that the one or more columns is needed for the query result, determining whether the one or more columns can be resolved using one or more input values of the query, the one or more input values comprising one or more equal predicates for the one or more columns; and in determining that the one or more columns can be resolved using the one or more input values of the query, resolving the query result using the one or more qualified record identifiers (RIDs) from the multiple indexes and substituting column values with the one or more equal predicates of the query without accessing the data pages of the database, wherein the resolving of the query result comprises: obtaining a list of qualified RIDs from each of the multiple indexes; intersecting or union the list of the qualified RIDs from each of the multiple indexes to create a merged RID list; and determining the query result using the merged RID list and substituting the column values with the one or more equal predicates of the query.

---

Claim 2:
2. The method of claim 1 , further comprising: in determining that the one or more columns cannot be resolved using the one or more input values of the query: storing one or more index keys corresponding to the one or more qualified RIDs from the multiple indexes with the one or more qualified RIDs; and resolving the query result using the one or more index keys stored with the one or more qualified RIDs without accessing the data pages of the database.