When shall I add ENCODING RLE for column during create projection

pdhoktepdhokte Vertica Customer

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