Oracle International Corporation

Satyanarayana R Valluri

Jiaqi Yan

Jesse Kamp

Dinesh Das

Prashant Gaharwar

Techniques are provided for determining costs for alternative execution plans for a query, where at least a portion of the data items required by the query are in in-memory compression-units within volatile memory. The techniques involve maintaining in-memory statistics, such as statistics that indicate what fraction of a table is currently present in in-memory compression units, and the cost of decompressing in-memory compression units. Those statistics are used to determine, for example, the cost of a table scan that retrieves some or all of the necessary data items from the in-memory compression-units.

Growing community of inventors

Batiment, Switzerland

Satyanarayana R Valluri