We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Materialized flex table vs Vertica general columnar table — Vertica Forum

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

  • Ariel_CaryAriel_Cary Vertica Employee Employee

    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