What are the performance implications for complex types over billions of rows?

Deb_ChatignyDeb_Chatigny Administrator
edited April 7 in General Discussion

Please talk about performance implications over millions/ billions of rows.

Question asked by an attendee during Putting Complex Data Types to Work. @DeepakMajeti

Answers

  • ChuckBChuckB Employee

    Millions/billions of times the implications over a single row :-)

    Kidding aside, it depends on what representation you choose. Flex tables, because the schema can change on each row and because the flex map is stored together, has a performance penalty over the columnar representation, until you decide to materialize frequently-used columns separately. Using the new complex types stuff, there isn't any overhead beyond the columnar representation, because it gets rewritten as columns, so it has the performance Vertica users have come to expect.

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.