Skip to Content
0
Former Member
May 18, 2016 at 08:03 PM

How to get query plan in Sybase IQ for running process

2441 Views

There 100 of processes are running . I want to see query plan for particular connection id .

like we have in sybase ASE .. sp_showplan <SPID>

I know we query plan optio as below ( either they will send out to msg file/standrad out)

1) set temporty option query_plan =on' -- this will work for query running in that session

2)

set temporary option query_plan_as_html = on

set option query_plan_as_html_directory = '<directory>'

I want to know if something like sp_showplan ...?

Appreciate for your help ...

Regards

Ajay Pandey