Data warehouse is a collection of huge database which is subject oriented, integrated, time-variant and non-volatile. As it is a set of huge database, fast data access is the major performance parameter of any data warehouse. Generally the information retrieved from data warehouse is summarized or aggregated as it is required for some decision making process of organization. To retrieve such an information queries to be fired is of the nature aggregation function followed by having clause. Extracting information efficiently from data warehouse is the challenge in front of researchers.