• Home
  • Recent Q&A
  • Java
  • Cloud
  • JavaScript
  • Python
  • SQL
  • PHP
  • HTML
  • C++
  • Data Science
  • DBMS
  • Devops
  • Hadoop
  • Machine Learning
in Dataware house by
Q:
What are Aggregate tables?

1 Answer

0 votes
by

Aggregate tables are the tables which contain the existing warehouse data which has been grouped to certain level of dimensions. It is easy to retrieve data from the aggregated tables than the original table which has more number of records.

This table reduces the load in the database server and increases the performance of the query.

Related questions

0 votes
asked Mar 23, 2020 in SAP by AdilsonLima
0 votes
asked Nov 13, 2021 in SQLite by sharadyadav1986
...