Search found 3 matches

by cilibar
Mon Jun 10, 2013 10:04 pm
Forum: Vertica Administration Tools
Topic: vertica plans, unresolved attributes
Replies: 2
Views: 16365

Re: vertica plans, unresolved attributes

I understand that this is the variable substitution but I just wanted to see why and when the optimizer does it. It seems nondeterministic.
Can I find somewhere the complete specification of plans that vertica produces?
by cilibar
Mon Jun 10, 2013 7:58 pm
Forum: Vertica Administration Tools
Topic: vertica plans, unresolved attributes
Replies: 2
Views: 16365

vertica plans, unresolved attributes

I was looking at some vertica plans produced with EXPLAIN command and it seems that for some expressions instead of real attribute names the plan prints <SVAR> . This happens even if I have different attributes (for all of them it prints <SVAR>). Here is the example for two aggregates over different...
by cilibar
Fri Jun 07, 2013 10:22 pm
Forum: Vertica Database Development
Topic: View Explain Plan
Replies: 7
Views: 25128

Re: View Explain Plan

Hi, I still do not entirely understand the explain plan of vertica and I was reading some documentations but still have some doubts. First, is there a way to know the schemata of individual operations, i.e., which attributes an operation receives at its input and which sends to an output (considerin...

Go to advanced search