Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    60

    Unanswered: db2expln information

    Hi,

    Does anyone have db2expln/dynexpln info or document link?
    I can use it but do not understand the output generated by it.

    For complex SQLs the output is just too large and complex and I do not know how to analyze the output.

    Any help is appreciated.

    Thanks,
    j

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Look in the Admin Guide: Performance reference manual for db2expln and db2exfmt. The second utility is a Format Tool for Explain.

    You could also use the GUI Command Center, turn on the option to automatically generate an access plan, then run your queries and the graphically view the plans (I find this method very helpful since you can zero in fairly quickly where problems are).

    HTH

    Andy

Posting Permissions

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