var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Informix - explain plan
Informix has a way to generate the explain plan, but the result is saved to a file on server. Is any way to get the explain plan back as Result Set over a jdbc connection ?
I'm not sure about directing the output to a result set, however you you specify the output file location and name using SET EXPLAIN FILE TO, eg:
But you will obviously need to have write permissions into the target directory or the file will not be written and an error will be returned
SET EXPLAIN FILE TO '/tmp/expl/sqexpl.out'
This is possible, but you have to be on IDS 11.70: see the EXPLAIN_SQL function, which IBM Data Studio and AGS Server Studio use to return an XML query plan into a BLOB before displaying it visually.