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

When shall I add ENCODING RLE for column during create projection

For example,
We have user_events table containing columns session_id, visitor_id & user_id.
The table has
total record count = 1 billion
distinct count for session_id = 100 million (10 records per session_id)
distinct count for visitor_id = 10 million (100 records per visitor_id)
distinct count for user_id = 1 million (1000 records per user_id)

For which columns shall I add 'ENCODING RLE'?



Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
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.