The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
when to use flattened tables?

Please let me know real time scenarios as well.
0
Answers
Hello,
Here's the definition by the admin:
How to create Flattened Tables:
vertica.com/docs/9.2.x/HTML/Content/Authoring/AnalyzingData/FlattenedTables/FlattenedTableCreate.htm essays.agency
In addition, as Flattened tables include columns that get their values by querying other tables,
Vertica executes the Flattened tables joins more efficiently and save the need to manually write and tune each Join.