Informix - explain plan

donose.mihai · #1 (**permalink**) 10-10-11, 04:27

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 ?

Thanks

T.Baron · #2 (**permalink**) 10-10-11, 15:12

Hi,

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:

Code:

SET EXPLAIN FILE TO '/tmp/expl/sqexpl.out'

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

douglawry · #3 (**permalink**) 10-10-11, 19:43

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.

Regards,
Doug Lawry
www.oninitgroup.com

Internet Services

Web Development

Digital Marketing

Consumer Tech