Light Access Plan Validation
Original Publication Date: 2004-Sep-13
Included in the Prior Art Database: 2004-Sep-13
When a database query optimizer or database statistics engine attempts to determine whether a saved query access plan can safely be reused, it may probe a variety of statistical sources including indexes, frequent value lists, histograms, and others. This probing may be system resource intensive. Described are several methods to determine that this probing is unnecessary in certain environments. Thereby, system resources are not consumed doing otherwise unnecessary probes.