摘要 |
A method, system, and computer program product to efficiently search a database is disclosed. The method, system, and computer program product may include structuring the database to have a table, an index associated with the table, and a log associated with the index, the log adapted to include an entry. The method, system, and computer program product may include receiving a search request related to the index. The method, system, and computer program product may include searching the index when the search request is not associated with the entry. The method, system, and computer program product may include accounting for the entry and searching the index when the search request is associated with the entry. |
主权项 |
1. A system comprising:
one or more processors; and program code including a query optimizer, the program code configured to be executed by the one or more processors to process a database query, the program code configured to:
structure a database to have a table, an index associated with the table, and a log associated with the index, the log adapted to include an entry;receive a search request related to the index;search the index when the search request is not associated with the entry; andaccount for the entry and search the index when the search request is associated with the entry. |