Skip to main content

Materialized flex table vs Vertica general columnar table

  • May 19, 2016
  • 1 reply
  • 6 views

xuyi

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

1 reply

Ariel_Cary
Forum|alt.badge.img
  • Participating Frequently
  • August 24, 2016

Hi Yi,

 

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