var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Frequent RUNSTAT for query performance
Hi I have one select query which loses performance on every alternate day and to give it back we do runstat that very table.
Can I get some suggestion on this why it is required on such a frequent basis, is there any parameter (may be value set is low) creating such problem.
Read the following article:
Capturing and accessing section actuals
Show us both "good" and "bad" access plans with section actuals.
I have got the two access plans for your analysis..
waiting for your opinion
Thanks!! After_runstats.txt explain_plan_during_issue.txt
quick and dirty
first thing i noticed was the INDEX IDOC.EVUID
The Values for sequences are different.
Is that an coincident, or is there a reorg in you runstats plan ?
Could you also check if there are autoreorgs in your system,
wich might be triggered by the runstat values ?