Hi , After investigating a problematic sql I saw that when we use CASE in the select it can lead to a major decrease in performance . Here is the example : the query is explain select a12.DT_WEEK AS DT_WEEK, a11.LP_ACCOUNT_ID AS LP_ACCOUNT_ID, CASE WHEN max(CASE WHEN a11.HOT_LEAD_IND = 1 THEN 1 ELSE...

znika: Thanks for the great post! That was very informative. Do you know if the Vertica Management Console has any tie in the profiling tables? It seems like a lot a work separating out all that data on the command line. It's be nice to view in a graphical interface. From what i know Vertica consol...

Sure

Thanks for the feedback.

another one is coming soon ...

Hi, I wrote a about Vertica trace. Hope you will find it helpful. Appreciate your comments. ================================= I come from Oracle Performance/Tuning World. Oracle has some great utilities that I use for tracking down problems and solving them. That's why when I approached Vertica I fi...