Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Best practices and tips for tuning analytical functions?
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Answers
First starting point is always EXPLAIN query.
If joins and nested queries are used CREATE LOCAL TEMPORARY TABLE can be a way out of the slow experience. Using those keep an eye on using the same segmentation for the temporary table as is used for the source table. If the output get's later inserted into another table compare the segmentation clause as well.
If possible develop the query with a smaller dataset on a slower system.
It might not work due to memory limits and gives ideas where to improve further.