A system for collecting database object statistics by a database management system selects one or more objects and corresponding one or more object fields and then creates a base set of statistics for the selected object fields. The system further reads active log records and updates the base set of statistics when a change is read in the active log records. Finally, the system begins extracting log records when an end-of-file of the active log records is reached, and updates the updated statistics based on the extracted log records.
展开▼
