Professional Web Applications Themes

Way To Generate Readable Explain Plan? - IBM DB2

Look at db2exfmt. "Carlos Rodriguez" <crodhenin.org> wrote in message news:4hBRa.380831$fC.2802648news.easynews.com... > Is there an SQL script that can read the information from the Plan table and > format the results so that it can be interpreted easily? > >...

  1. #1

    Default Re: Way To Generate Readable Explain Plan?

    Look at db2exfmt.

    "Carlos Rodriguez" <crodhenin.org> wrote in message
    news:4hBRa.380831$fC.2802648news.easynews.com...
    > Is there an SQL script that can read the information from the Plan table
    and
    > format the results so that it can be interpreted easily?
    >
    >

    Erik Hendrix Guest

  2. #2

    Default Re: Way To Generate Readable Explain Plan?

    You can write some sql script to query explain tables.
    DB2 does suggest use db2 tools which can give more helpful information about
    access plan.
    Regards,
    FRX

    Carlos Rodriguez wrote:
    > Is there an SQL script that can read the information from the Plan table and
    > format the results so that it can be interpreted easily?
    Fan Ruo Xin Guest

Similar Threads

  1. Explain Plan for queries
    By ovkrishna in forum Informix
    Replies: 8
    Last Post: October 27th, 04:31 PM
  2. Marty,I Have Another Explain Plan Question
    By Richard Winston in forum IBM DB2
    Replies: 4
    Last Post: September 15th, 08:05 PM
  3. Replies: 4
    Last Post: September 15th, 06:11 PM
  4. x += 1 in readable code
    By Mark J. Reed in forum Ruby
    Replies: 6
    Last Post: July 20th, 04:06 AM
  5. Explain plan for SQL stored procedure
    By Onno Ceelen in forum IBM DB2
    Replies: 5
    Last Post: June 30th, 08:04 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139