Hi,
What is the best encoding type for a varchar that stores people last name? Obviously the cardinality is low. Should I just leave it AUTO?
-Thanks
Best encoding type for people's names
Moderator: NorbertKrupa
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Best encoding type for people's names
AUTO will probably use Lempel-Ziv-Oberhumer-based (LZO) compression for varchars. You can always run DBD to see what it comes up with.
Checkout vertica.tips for more Vertica resources.
Re: Best encoding type for people's names
Just to add to norbert's reply.
IF you are running DBD make sure, you have enough of sampling data in the table / column for the DBD
Hope this helps
IF you are running DBD make sure, you have enough of sampling data in the table / column for the DBD
Hope this helps
Re: Best encoding type for people's names
Thanks, all. I figured auto was probably the best. I am going to post another question in a different topic about how to run DBD on a single table.