var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: runstats on table with no indexes
Is it necessary to perform runstats on a table with no indexes. DB2 has to scan the table anyway. Where can runstats help? Please explain.
At least, it might influence on join method(and join sequence, if you joined more than two tables).
No joining with other tables. This table is an MQT and is queried directly. No indexes are created on MQT. Any benefit from runstats?
If the query for base table was not and you queried MQT directly,
I can't expect any benefit from runstats(in that very limited situation).