Adaptive Server Enterprise 15.0.2 ESD #4 and later supports set statistics io for parallel queries.
set statistics io on
Use set statistics io on to obtain a representation of the parallel access nodes.
See Chapter 6, “Ensuring Stability and Performance,” in the Migration Guide for command syntax and usage details.
set statistics io on
go
select a.c1, max(a.c2) from r10 a, r10 b where a.c2 = b.c2 group by a.c1
go
Table: Worktable2 scan count 1, logical reads: (regular=5 apf=0 total
physical reads: (regular=0 apf=0 total=0), apf IOs used=0
Table: r10 scan count 1, logical reads: (regular=10 apf=0 total=10),
reads: (regular=0 apf=0 total=0), apf IOs used=0Table: r10 scan count 1, logical reads: (regular=10 apf=0 total=10),
reads: (regular=0 apf=0 total=0), apf IOs used=0Total writes for this command: 0
