Vertica Quick Tip: Default Size of the NUMBER Data Type

Moderator: NorbertKrupa

Post Reply
User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1824
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Vertica Quick Tip: Default Size of the NUMBER Data Type

Post by JimKnicely » Mon Feb 05, 2018 9:58 pm

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

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Links”