Informix/informix reference
Dynamic turning on and off of SQL Explain
@ipajama
2014. 1. 2. 11:11
728x90
Problem(Abstract)
To turn on or off the SQL Explain in the IDS engine while SQL
is running, use the onmode -Y command.
The syntax:
onmode -Y
<session id> 2
onmode -Y <session id> 1
onmode -Y <session
id> 0
The option with 2 turns SET EXPLAIN on for sessionid and
displays the query plan only
The option with 1 turns SET EXPLAIN on for
sessionid
The option with 0 turns SET EXPLAIN off for sessionid
http://www-01.ibm.com/support/docview.wss?uid=swg21661115&myns=swgimgmt&mynp=OCSSGU8G&mync=E
728x90