Vertica Quick Tip: Default Size of the NUMBER Data Type
Posted: Mon Feb 05, 2018 9:58 pm
Vertica Community Blog post authored by Jim Knicely
Read more here:
https://my.vertica.com/blog/vertica-qui ... data-type/
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/