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:
https://my.vertica.com/blog/vertica-qui ... data-type/