Patent ID: 8935231
Filing Date: 2015-01-13
Classification: G06F

Abstract:
1. An apparatus comprising: at least one processor; a memory coupled to the at least one processor; and a query optimizer residing in the memory and executed by the at least one processor, the query optimizer generating a virtual maintained temporary index that spans a plurality of partitions in a partitioned database table, wherein the query optimizer creates an access plan for a query that references the partitioned database table, wherein the access plan references the virtual maintained temporary index, wherein the query optimizer registers ownership of a virtual maintained temporary index by an access plan when the virtual maintained temporary index is referenced in the access plan, wherein the query optimizer disables deletion of the virtual maintained temporary index when the virtual maintained temporary index is owned by at least one access plan, wherein the query optimizer enables deletion of the virtual maintained temporary index when the virtual maintained temporary index is not owned by any access plan.