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