Patent ID: 9292572
Filing Date: 2016-03-22
CPC Classification: G06F

Claim Text:
1. A method for determining costs for access plans for databases access, the method comprising: collecting profile data for each of a plurality of database indices of a database hosted across a plurality of storage devices, wherein the profile data at least indicates whether each of the plurality of database indices is clustered or non-clustered and a type of one of the plurality of storage devices that hosts each of the database indices; selecting weights for each of the plurality of database indices based, at least in part, on the profile data including whether each of the plurality of database indices is clustered and the type of the one of the plurality of storage devices; calculating a respective cost for each of the plurality of database indices using the selected weights; associating in storage the respective cost for each of the plurality of database indices with each of the database indices; and computing access plan costs for a plurality of access plans generated for a query responsive to receiving the query, wherein said computing the access plan costs uses the respective costs for those of the plurality of database indices that correspond to the plurality of access plans.