METHOD AND SYSTEM FOR PROVIDING COST MODEL DATA FOR TUNING OF QUERY CACHE MEMORY IN DATABASES

摘要

Providing cost model data for tuning query cache memory size in database systems. In one aspect, a query is received, and a query cache is checked to determine whether a stored query matches the received query. When a cache miss has occurred due to no stored queries matching the received query, the processing time saved by the avoidance of the cache miss and a cache size needed to avoid the cache miss are determined.