Do you make "Flush Package Cache Dynamic" part of your RUNSTATS
routine ?
In other words do you follow runstats with FLUSH PACKAGE CACHE DYNAMIC
at the end ?

I was reading Websphere best practices when it comes to db maintenance
scripts and saw the flush package statement at the end and wondering
if it is necessary.

As a matter of fact, if you created a new index for a table with
existing data, are you suppose to runstats for that index too ?

Look forward to your replies. Thanks.

RL

"Richard" <rsl101 (AT) gmail (DOT) com> wrote

I do, but not really sure whether it is needed.

On Mar 28, 8:35*pm, Richard <rsl... (AT) gmail (DOT) com> wrote:
You should make COLLECT (SAMPLED DETAILED) STATISTICS part of your
CREATE INDEX statement to ensure that the optimizer will use it, if
appropriate.

Regards
Odd B Andersen, EDB ErgoGroup AS, Oslo, Norway

I always specify collect statistics as part of the index creation
statement. If the IO's have to be done anyway, you might as well use
them to get the correct statistics too.

--
Frederik Engelen

Thank you experts. I never heard of COLLECT option on CREATE INDEX
before but will use it now.
Is it same as runstats for index ?

RL

On Mar 29, 3:27*pm, Richard <rsl... (AT) gmail (DOT) com> wrote:
As far as I know, yes.

--
Frederik Engelen