Time-based rebuilding of autonomic table statistics collections

Data processing: database and file management or data structures – File or database maintenance – Synchronization

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

Reexamination Certificate

active

07949631

ABSTRACT:
Building database statistics for use by a query optimizer is beneficial but may over utilize system resources. Accordingly, the frequency that statistics are rebuilt is controlled in order to minimize the effect of the system. In particular, the staleness of the data and the time since the last statistics collection are used to determine whether or not to re-collect statistics. Even for relatively stale data, statistics are not rebuilt until a predetermined time period has passed.

REFERENCES:
patent: 2004/0243555 (2004-12-01), Bolsius et al.
patent: 2005/0086242 (2005-04-01), Ngai et al.
patent: 2005/0086263 (2005-04-01), Ngai et al.
patent: 2005/0203940 (2005-09-01), Farrar et al.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Time-based rebuilding of autonomic table statistics collections does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Time-based rebuilding of autonomic table statistics collections, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Time-based rebuilding of autonomic table statistics collections will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-2649573

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.