set statistics plancost

Adaptive Server Enterprise 15.0.2 ESD #4 and later supports set statistics plancost on for parallel queries.

set statistics plancost on

Use set statistics plancost on to obtain a representation of the parallel access nodes in the lava operator tree.

See Chapter 6, “Ensuring Stability and Performance,” in the Migration Guide for command syntax and usage details.

set statistics plancost on

go

select a.c1, max(a.c2) from r10 a, r10 b where a.c2 = b.c2 group by a.c1

go

===============Lava Operator Tree ================
                  Emit
                  (VA = 6)
                  r:100 er:100
                  cpu: 0
                /
                HashVectAgg
                Max
                (VA = 5)
                r:100 er:100
                l:5 el:5
                p:0 ep:0
                bufct: 16
             /
             Exchange
             P(2)  C(1)
             (VA = 4)
             r:100 er:100
             l:0 el:1
             p:0 ep:0
        / 
        ExchangeEmit
        (VA = 3)
        r:100 er:100
        l:0 el:1
        p:0 ep:0
     /
     HashJoin
     Inner Join
     (VA = 2)
     r:100 er:100
     l:10 el:5
     p:0 ep:0
     bufct: 16
/                      \
TableScan               TableScan
r10 (a)                 r10 (b)
(VA = 0)                (VA = 1)
r:100 er:100            r:100 er:100
l:100 el:100            l:100 el:100
p:0 ep:100              p:0 ep:100

======================================================