Data management system that provides intelligent access plan caching
View Patent ↗Disclosed is an apparatus, method, and program product for performing efficient database access plan caching. Unlike prior art mechanism that automatically discard stored access plans whenever the need for a different access plans is detected, stored plans are intelligently retained despite the handling of one or more infrequent queries that call for the use of a different plan.
1. An apparatus, said apparatus comprising:
a processor;
memory; and
a database system, said database system residing in said memory, said database system creating a first access plan for a query, saving said first access plan, and using said first access plan for executing said query at least once, said database system subsequently creating a second access plan for said query upon encountering a data-specific consideration and using said second access plan for executing said query at least once, said database system selectively retaining said first access plan as a saved access plan for said query after encountering said data-specific consideration despite creating said second access plan for said query;
wherein upon each receipt of said query said database system determines a value of said first access plan and retains said first access plan when dictated by said value determination and wherein said database system discards said first access plan and retains said second access plan when dictated by said value determination.
2. The apparatus of claim 1 wherein said value determination is a ratio involving how often said first access plan is reused and how often said second access plan is created.
3. The apparatus of claim 1 wherein said data-specific consideration is data skew.
4. A program product, said program product comprising:
computer-readable storage media; and
a database system disposed on said computer-readable storage media, said database system residing in said memory, said database system creating a first access plan for a query, saving said first access plan, and using said first access plan for executing said query at least once, said database system subsequently creating a second access plan for said query upon encountering a data-specific consideration and using said second access plan for executing said query at least once, said database system selectively retaining said first access plan as a saved access plan for said query after encountering said data-specific consideration despite creating said second access plan for said query;
wherein upon each receipt of said query said database system determines a value of said first access plan and retains said first access plan when dictated by said value determination and wherein said database system discards said first access plan and retains said second access plan when dictated by said value determination.
5. The program product of claim 4 wherein said value determination is a ratio involving how often said first access plan is reused and how often said second access plan is created.
6. The program product of claim 4 wherein said data-specific consideration is data skew.
7. A computer-implemented method, said method comprising the steps of:
creating a first access plan for a query, saving said first access plan, and using said first access plan for executing said query at least once;
determining a value of said first access plan upon each receipt of said query;
subsequent to said steps of creating, saving and using said first access plan, creating a second access plan for said query upon encountering a data-specific consideration and using said second access plan for executing said query at least once;
selectively determining whether to retain said first access plan as a saved access plan for said query after encountering said data-specific consideration, said selectively determining step determining to retain said first access plan when dictated by said value determination;
responsive to said selectively determining step determining to retain said first access plan, retaining said first access plan as a saved access plan for said query despite creating said second access plan for said query; and
discarding said first access plan and retaining said second access plan when dictated by said value determination.
8. The computer-implemented method of claim 7 wherein said value determination is a ratio involving how often said first access plan is reused and how often said second access plan is created.
9. The computer-implemented method of claim 7 wherein said data-specific consideration is data skew.