Browse Prior Art Database

Light Access Plan Validation

IP.com Disclosure Number: IPCOM000031126D
Original Publication Date: 2004-Sep-13
Included in the Prior Art Database: 2004-Sep-13

Publishing Venue

IBM

Abstract

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.