The Vertica Database Forums

Hi all ,
I've a question, i need optimize a query and i don't know how?. Normally i use explain instruction but the result is too confused [http://pastebin.com/KbCB0uuH and the query http://pastebin.com/fnm4KJQZ]. I read the documentation but need help to understand the bottleneck.
Any idea? other tool aside explain?
Thanks alot

Hi,

First, please run statistics on the tables. Your plan shows that you have NO STATISTICS.

Use the following command to update your stats for the entire DB:

Hi JimKnicely,
i run the instruction and follow the documentation https://my.vertica.com/docs/5.0/HTML/Master/16384.htm and https://my.vertica.com/docs/5.0/HTML/Master/14149.htm
http://pastebin.com/BvWRNXxQ
Thanks for all

JimKnicely wrote:Hi,

First, please run statistics on the tables. Your plan shows that you have NO STATISTICS.

Use the following command to update your stats for the entire DB:

Code: Select all

SELECT analyze_statistics('');