7. The computer-implemented method of claim 6 , wherein the first constraint refines a first specified statistical view candidate by imposing a limit on a total count of columns in the first specified statistical view candidate, wherein the second constraint refines the plurality of statistical view candidates by imposing a limit on a total count of statistical views generated from the plurality of statistical view candidates, wherein the computer-implemented method further includes identifying, for the database workload, a set of criteria one or more one or more fact tables, one or more dimension tables, one or more express joins, and one or more implied joins, the set of criteria further including the respective arity for each of the plurality of joins and the respective skew for each of the plurality of joins, wherein the plurality of statistical view candidates is generated based on the identified set of criteria, wherein the third constraint refines the plurality of statistical view candidates by imposing a limit on a total count of statistical views generated from the plurality of statistical view candidates, for a specified database table.
7. The computer-implemented method of claim 6 , wherein the first constraint refines a first specified statistical view candidate by imposing a limit on a total count of columns in the first specified statistical view candidate, wherein the second constraint refines the plurality of statistical view candidates by imposing a limit on a total count of statistical views generated from the plurality of statistical view candidates, wherein the computer-implemented method further includes identifying, for the database workload, a set of criteria one or more one or more fact tables, one or more dimension tables, one or more express joins, and one or more implied joins, the set of criteria further including the respective arity for each of the plurality of joins and the respective skew for each of the plurality of joins, wherein the plurality of statistical view candidates is generated based on the identified set of criteria, wherein the third constraint refines the plurality of statistical view candidates by imposing a limit on a total count of statistical views generated from the plurality of statistical view candidates, for a specified database table. 8. The computer-implemented method of claim 7 , wherein the fourth constraint refines a second specified statistical view candidate by imposing a limit on a total amount of storage used to store statistics collected for the second specified statistical view candidate, wherein the fifth constraint refines a third specified statistical view candidate by imposing a limit on an estimated execution time for collecting statistics for the third specified statistical view candidate; wherein refining the plurality of statistical view candidates comprises at least one of adding, deleting and updating at least one statistical view candidate, wherein at least one pre-existing statistical view is, in respective instances, merged, updated, and deleted, based on retrieved information indicating that the pre-existing statistical view has no effect on decision-making of a query optimizer component of the database management system.