It that possible query optimization ?

HyeontaeJuHyeontaeJu Vertica Customer

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?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file