Hi, i have a problematic query which originally doesnot finish at all. then i created query specific projection for "dwh" schema, after which this query takes 83 mins. i need to further tune this query and need some advises and recommendations. i am attaching the following :- 1) query 2) explain pl...

Thanks...yes I am able to see the queries hitting database. But when I execute any MicroStrategy report from web which is pointing to the Vertica database then I do not see it's entry in the QUERY_PROFILES table. Where does this is recorded? Query profiles will include only the active transaction U...

Thanks for the test

Does merge ( when it updates the row ) behave like an update ?
what i mean is when it updates it will delete and insert a row ?

what about the the deleted vectors ? this can kill performance if we will have a lot .

janice wrote:I'm interested in reading your document! Is there a way to view it without being a member of linked in?

ssend me you email and i will reply.

Hi Vertica architecture based on sroting the columns in the projections. So, if you will use the same sort as the projection you can even get better performance, how ? Sometimes the optimizer faile to pick the right projection . if you will add an order by to the query the optimizer will then pick t...

Presentation i gave about Vertica architecture and performance tuning for developers.
Enjoy
http://slidesha.re/JkmtBL

Thanks! So you installed the console? Did you install it on its own server? I was think about sticking it on one of my nodes but the docs say not to do that. Maybe I'll just wait until version 6. Well ... As i said it's not mature enough . Wait for version 6 if you can . p.s yes we installed it on ...