: 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