Vertica Quick Tip: Avoid Using Functions on Very Large Data Sets

Moderator: NorbertKrupa

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

Vertica Quick Tip: Avoid Using Functions on Very Large Data Sets

Post by JimKnicely » Fri Jan 26, 2018 2:21 pm

This blog post was authored by Jim Knicely.

You can store billions and billions and billions (i.e., a lot) of records in your Vertica tables. When querying these large data sets, try to avoid using database functions like TO_DATE, TO_CHAR, NVL, etc. when unnecessary.

Read more here:
https://forum.vertica.com/discussion/23 ... -data-sets
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”