Aggregate table and materialized view

Write down the differentiation between aggregate table and materialized view.

E

Expert

Verified

Aggregate table is the generic term which is used to represent the summaries which is built in a warehouse. Materialized view is the technical execution of such aggregate tables. Though, Materialized views come with database precise properties which may not be covered with generic definition of the aggregate tables.

   Related Questions in Other Subject

©TutorsGlobe All rights reserved 2022-2023.