Very Computer

I read in one of the recent posts that to maintain optimum performance for
ABF, you should do an optimizedb with the -zc flag.  
Our DBA Guide (Version 6.4.05) doesn't even show this flag. Was this
changed between versions?  We run optimizedb with -zk flag on all our
databases.  Is there something else I should be doing? - I did a "Help
table" on one of the system catalog tables, and no statistics show.

Thanks in advance,

Elaine Verhelst

Elaine/Frank,

The DBA Guide usually doesn't show all options.  Rather it has IN DEPTH
discussions on SOME options of particular relevance to DBA's.  "-zc"
is in the Ingres/SQL Command Summary and probably in the SQL Reference
Manual.

Quote:

> I read in one of the recent posts that to maintain optimum performance for
> ABF, you should do an optimizedb with the -zc flag.  
> Our DBA Guide (Version 6.4.05) doesn't even show this flag. Was this
> changed between versions?  We run optimizedb with -zk flag on all our
> databases.  Is there something else I should be doing? - I did a "Help
> table" on one of the system catalog tables, and no statistics show.

> Thanks in advance,

> Elaine Verhelst

--

                Telephone: +61 3 9344 6003      Fax +61 3 9347 4803
Manager Administrative Systems Processing, Information Technology Services,
The University of Melbourne, Parkville, Australia.  3052.
                President, Victorian Ingres Users Association

: I read in one of the recent posts that to maintain optimum performance for
: ABF, you should do an optimizedb with the -zc flag.  
: Our DBA Guide (Version 6.4.05) doesn't even show this flag. Was this
: changed between versions?  We run optimizedb with -zk flag on all our
: databases.  Is there something else I should be doing? - I did a "Help
: table" on one of the system catalog tables, and no statistics show.
:  

What you should do, is optimisedb on all columns that appear in a where
clause of all your SQL statements. That way the optimiser can do its job
the way it was designed.

--
======================================================================
|  Hamish Marson                                                     |


|  University of Waikato           | PHONE    +64 7 8562889 xt 8181  |
|  New Zealand                     | FAX      +64 7 8384066          |
===========Disclaimer :- Remember. You heard it here first.===========
If nuclear bombs are so safe why don't the French test them under Paris