Vertica Quick Tip: Avoid Using Functions on Very Large Data Sets
Posted: 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