STATISTICS FORECAST FOR RANGE PARTITIONED TABLES

摘要

A method of running a query for a database having partitioned tables. The method includes loading data into a table partition; forecasting statistics for the table partition based on previously gathered partition statistics using a data mining algorithm; and subsequently to forecasting statistics, running a query by a query optimizer; and wherein the method is performed by one or more computing devices. Also disclosed is a computer program product and a system.