It that possible query optimization ?

HyeontaeJu

Hello, I have 4 big table a, b, c, d. each table have about 300 million data.
I wanna inner join a, b, c, d. but, when i was using this query, the cpu usage is top in the system..
Even this query is intended to be used on a web page as a paging query, so it should appear within at least 10 seconds. Is this possible?

Sankarmn

Check these,
https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/AnalyzingData/Optimizations/OptimizingQueryPerformance.htm
https://www.vertica.com/kb/Redesigning-Projections-for-Query-Optimization/Content/BestPractices/Redesigning-Projections-for-Query-Optimization.htm
and the checklist, https://www.vertica.com/blog/query-tuning-vertica-dos-donts/