5. The method of claim 4 , wherein the query execution comprises: reading a key for a data row; determining whether the key contains one or more trailing blanks; in determining that the key contains the one or more trailing blanks, resolving the query result by accessing the data pages of the database; and in determining that the key does not contain any trailing blanks, resolving the query result using the one or more qualified RIDs from the multiple indexes and the input values of the query without accessing the data pages of the database.
4. 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; and in determining that the one or more columns is not needed for the query result, resolving the query result using one or more qualified record identifiers (RIDs) from the multiple indexes without accessing data pages of the database, comprising: determining whether the one or more columns is a variable length column; and in determining that the one or more columns is not the variable length column, resolving the query result using the one or more qualified RIDs from the multiple indexes and the input values of the query without accessing the data pages of the database; and in determining that the one or more columns is the variable length column, including a conditional data page access during a query execution.