Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    246

    Unanswered: db2advis partition

    Hi,

    Have 5 logical partition V 9.1 FP 6 aix,

    query performance issue, as doing lot of rows read in all 5 nodes

    While running db2advis from catalog node it suggested few indexes but the improvement was on 12 %

    Question

    This improvment details its giving for 1 single node or for all 5 nodes. ??

    regards
    Paul

  2. #2
    Join Date
    Nov 2011
    Posts
    334
    hi,
    I think the improvement detailes is for your sql cost.
    12% = ( old cost - new cost ) / old cost * 100 %
    old cost = sql cost before index created
    new cost = sql cost after index created

Posting Permissions

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