
If Your Version is 11.5 or 11.9.x
64
However, be cautious about adding new statistics to the production
environment until you have determined your needs and tested any changes. Not
all new statistics are needed or helpful in every environment.
Warning! Making unneeded changes to statistics may adversely affect
performance. In addition, running the
update statistics command with
incorrect parameters may change the number of steps in a histogram and
impact performance. Apply changes first in a test environment. See the
Performance and Tuning Guide at
http://manuals.sybase.com:80/onlinebooks/group-
as/asg1250e/perf/@Generic__BookView for information.
Trace Flag 326
trace 326 no longer exists in ASE 11.9.2 or above. In pre-11.9.2 trace 326 used
arithmetic averaging to establish the total density value rather than the default
geometric averaging. If you used
trace 326 in earlier versions of ASE (perhaps
in the RUNSERVER file with the
-T flag) you now have to manually change the
total density value via
optdiag.
If Your Version is 11.5 or 11.9.x
This section covers the following topics:
• Documentation Changes
• Backup Server
• Suspending Updates to Databases for Copying
• New Unix File System Device Support
• Changes to dbids
• CIS Proxy Databases
• ASE Plug-in for Sybase Central
• The sybsyntax Utility
Commenti su questo manuale