FW: Update statistics 
Author Message
 FW: Update statistics

Sorry, keep on forgetting about MIME (using Microsoft Outlook). Here is
another copy -

I've read about this in the manuals,  I've asked advise and looked at
samples, but update statistics is still not 100% clear to me.

I also got different answers from different people with regards to how it
must be done.  On my machine I run -

update statistics low drop distributions;  (whole database)
update statistics high (for all leading columns indexes - using the
sysindexes.part1 column)
update statistics medium (for all other  columns used in indexes -
nonleading columns in indexes)
update statistics for procedure;

Is this correct ?

I've also written a 4gl program (because I don't like  the scripts too much)
that is a little different -

I still run update statistics low drop distributions; (whole database)
it will then update statistics high for all leading  columns in indexes, and
on all other columns (if they are used in  indexes or not) I run update
statistics medium.

Can anyone give me a short and exact answer as to how it must be done ?

Thanks
Dirk

Dirk Moolman
Database Administrator
Reach Technologies

"Bravery is the capacity to perform properly even when scared half to
death."
- General Omar Bradley



Wed, 18 Jun 1902 08:00:00 GMT
 FW: Update statistics

     > I've read about this in the manuals, I've asked advise and
     > looked at samples, but update statistics is still not 100%
     > clear to me.

     > I also got different answers from different people with regards
     > to how it must be done.  On my machine I run -

     > update statistics low drop distributions; (whole database)
     > update statistics high (for all leading columns indexes - using
     > the sysindexes.part1 column) update statistics medium (for all
     > other columns used in indexes - nonleading columns in indexes)
     > update statistics for procedure;

     > Is this correct ?

I dunno.  However, you may find Art Kagel's dostats utility to be
helpful at providing a very good first guess as to how to update
statistics properly.  Look in www.iiug.org under DB Adminstration Tools
you'll find it packaged along with other very useful stuff in a file
called utils_ak2.  It requires ESQL/C which you can get for free at
www.intraware.com.

HTH,

Mark
--
"Lack of will power has caused more failure than lack of intelligence
or ability."
        -- Flower A. Newhouse



Wed, 18 Jun 1902 08:00:00 GMT
 FW: Update statistics
We set up Douglas Wilson's updstats perl script to create the update statistics
SQL.
It runs every evening after backups..
http://www.iiug.org/members/memb_software/archive/upd_stats
Quote:

> Sorry, keep on forgetting about MIME (using Microsoft Outlook). Here is
> another copy -

> I've read about this in the manuals,  I've asked advise and looked at
> samples, but update statistics is still not 100% clear to me.

> I also got different answers from different people with regards to how it
> must be done.  On my machine I run -

> update statistics low drop distributions;  (whole database)
> update statistics high (for all leading columns indexes - using the
> sysindexes.part1 column)
> update statistics medium (for all other  columns used in indexes -
> nonleading columns in indexes)
> update statistics for procedure;

> Is this correct ?

> I've also written a 4gl program (because I don't like  the scripts too much)
> that is a little different -

> I still run update statistics low drop distributions; (whole database)
> it will then update statistics high for all leading  columns in indexes, and
> on all other columns (if they are used in  indexes or not) I run update
> statistics medium.

> Can anyone give me a short and exact answer as to how it must be done ?

> Thanks
> Dirk

> Dirk Moolman
> Database Administrator
> Reach Technologies

> "Bravery is the capacity to perform properly even when scared half to
> death."
> - General Omar Bradley



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Fw: update statistics not recommended!

2. FW: Update Statistics - 7.23

3. FW: How to improve the performance of update statistics - DBUPSPACE

4. FW: FW: FW: FW: Explain (more is better?)

5. Performance Issues with UPDATE STATISTICS WITH FULLSCAN on _WA_Sys auto statistics

6. FW: FW: FW: Same configuration ?

7. FW: Queue statistics

8. FW: Informix Statistic

9. Fw: Redbrick Memory Management & Statistics

10. FW: FW: FW: Explain (more is better?)

11. FW: Table updates / update stats

12. ANNOUNCE: Another update statistics utility - latest update


 
Powered by phpBB® Forum Software