EXPORT_OBJECTS will show the CREATE statement: d2=> select export_objects('','raiseXY'); export_objects CREATE PROCEDURE public.raiseXY(x int, y varchar) LANGUAGE 'PL/vSQL… (View Post)

Encoding: Set all fields to ZSTD_FAST_COMP to improve load and query times. Segmentation: the JOIN condition is product_id, so tables should be segmented by product_id so values are colocated. If one… (View Post)

@BHIFP Is it possible to rewrite the query, or rewrite the logic calling the query? We've improved the performance of Common Table Expressions with temp relations so I wonder if the query could … (View Post)

If you need an integer difference in seconds from UTC times, try the following: SELECT (EXTRACT(EPOCH from a.END_TIME_UTC) - EXTRACT(EPOCH from a.START_TIME_UTC)) as hhmmss https://www.vertica.com/do… (View Post)

Have you tried loading a sample of data and running Database Designer using that sample table and one or more queries as samples? Low cardinality columns may not impact distribution as much as you th… (View Post)