The Vertica Database Forums

Hi All,

I want to create a table with ENCODING rules. i just want to understand what is the best encoding for what data type. its great worth for me if you post in below format....


varchar---
char---
integer----
numeric----
Date--

example:

timestamp--- GCDDELTA <-----EXAMPLE

The easiest thing to do is run database designer after loading some data. DBD will determine the best encoding for the data in your columns. Otherwise, see the documentation on encoding types.

Hi!

[DELETED]

RLE on a rowid doesn't seem very optimal and sticks out like a sore thumb in your example. I think it is important to note that you need real, representative data in these tables before running DBD or related API.

Also, DBD can be run without deployment if you just want to look over the scripts. It's less targeted, but simpler and might show you other areas of interest in your projection design.