what is the best partices adding the ENCODING
a) while creating table?
b) while creating projection.
which is best option and why it is best..
Hi ,I see two main practical options :
I hope you will find it usefulThanks .
1. Encoding type depends of data type. Recomended encoding for data types easy to find in oficial documentation
2. Encoding gives great performance on where clause fields, join fields (especially in merge join if encoding type equals on both sides), sort fields and etc
Predicates on columns whose data is encoded in certain formats, such as run-length encoding, can be applied directly on the encoded data, thus bypassing the overhead of decompression and reducing the quantity of
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.