Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2011
    Posts
    19

    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 ?

    Thanks

  2. #2
    Join Date
    Oct 2011
    Posts
    1
    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

  3. #3
    Join Date
    Feb 2011
    Location
    London
    Posts
    6
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •