var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: db2advis partition
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 %
This improvment details its giving for 1 single node or for all 5 nodes. ??
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