Page 1 of 1

Vertica Quick Tip: Default Size of the NUMBER Data Type

Posted: Mon Feb 05, 2018 9:58 pm
by JimKnicely
Vertica Community Blog post authored by Jim Knicely
When creating a table where you do not define a precision for a NUMBER column data type, Vertica will use a default precision of 38 digits. Often this is larger than necessary. By specifying NUMBER(37) you will potentially get better query performance and save on storage. Why? It’s all about the data type size.

Read more here: ... data-type/