SET OPTION PUBLIC.Query_Plan_Text_Access = 'ON'
go
SELECT HTML_PLAN('select * from ndg_compute')
go
SELECT GRAPHICAL_PLAN('select * from ndg_compute')
You'll probably also want:
set temporary option QUERY_DETAIL = 'on'
set temporary option QUERY_TIMING = 'on'
http://www.sybase.com/detail?id=1067116#CIHEIDCE
http://www.sybase.com/detail?id=1067116#CIHEIDCE
Jenny - lets discuss with Ivan prior to starting. He has done some initial work here.
Jenny - lets discuss with Ivan prior to starting. He has done some initial work here.
set temporary option QUERY_PLAN_AFTER_RUN = on generated the additional Query Timings Chart with CPU thread etc.
set temporary option QUERY_PLAN_AFTER_RUN = on generated the additional Query Timings Chart with CPU thread etc.
Issue #5111 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build 13.0.1-2 |
No time estimate |
You'll probably also want:
set temporary option QUERY_DETAIL = 'on'
set temporary option QUERY_TIMING = 'on'