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'