Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Materialized flex table vs Vertica general columnar table

Dear peers from the community, 

 

In term of query performance, is a materialized flex table equivalent to a general Vertica columnar table (with the same columns and contents, except that the materialized flex table has two extra columns "__identity__" and "__raw__")? 

 

Thanks,

Yi

Comments

  • Hi Yi,

     

    Yes, performance is the same between flex table and columnar table that have the same schema and projections.

     

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.