1. An apparatus comprising: a computer system comprising a processor coupled to a memory; an application executing in the memory with a query to a database; and a database manager with a disappearing index mechanism to manage the database, wherein the disappearing index mechanism processes the query with an initially full index and removes values from the index for query operations that do not select a record to create a sparse index while processing the query.