The Vertica Database Forums

Hi!

[DELETED]

I'm providing the link to your StackOverflow question to avoid cross-posting and show what others have suggested.

I threw your profile results into Excel and sorted on the counter_value column. The costliest operations are (not surprisingly) the JOIN's. At this point, I would suggest that you explore Pre-join Projections and Join Predicates if you plan on using your query. Like I mentioned on your StackOverflow question, you may want to consider de-normalizing your schema (if possible).

Much appreciated. I don't yet know how much the communities overlap (SO, here, and http://community.vertica.com/ ) so I'm learning.

I've found that community.vertica.com is the least helpful. I've had several open questions on there for quite some time with no activity. StackOverflow and these forums seem to be the best resources IMO.

Hi!

[DELETED]

Hi!

[DELETED]

Hi!

[DELETED]