International Journal of Advanced Research in IT and Engineering ISSN: 2278-6244 Vol. 2 | No. 6 | June 2013 www.garph.co.uk IJARIE | 1 EFFECT OF CUBE ON QUERY PERFORMANCE IN DATA WAREHOUSE Ashok Kumar Verma* Abstract: A way to improve performance when processing large amounts of data in a data warehouse is to build aggregates. A query answered from base-level data can take hours and involve millions of data records and millions of calculations. With precalculated aggregates, the same query can be answered in seconds with just a few records and calculations. Building aggregates from dimensional models is a simple approach because each large fact table can provide numerous aggregates with a predictable structure and a predictable relationship to the base fact table. There are three basic ways to build aggregates from the fact table in this type of model. The first approach is to exclude one or more dimensions when summarizing a fact table. This is the easiest type of aggregate to create because the diŵeŶsioŶal data doesŶ’t Ŷeed to ďe aĐĐessed. The aggregate ĐaŶ also provide significant performance advantages over the base fact table. Keywords: Data warehouse, aggregate, Percent performance gain, Memory optimization, Size of cube. *M. Tech (Software Engineering), Sri Ram Murty College of Engineering and Technology, Bareilly