6. The method of claim 4 , wherein grouping one or more WMQTs, one or more BMQTs and one or more other candidates into one or more groups to merge into a set of a smaller number of MQTs comprises examining predicate distributions in one or more sampled workloads to determine a level of consolidation.
6. The method of claim 4 , wherein grouping one or more WMQTs, one or more BMQTs and one or more other candidates into one or more groups to merge into a set of a smaller number of MQTs comprises examining predicate distributions in one or more sampled workloads to determine a level of consolidation. 7. The method of claim 6 , wherein examining predicate distributions in one or more sampled workloads to determine an appropriate level of consolidation comprises dividing predicates observed on a column in a sample workload by using a same histogram grouping that a host database management system (DBMS) uses on the column.