Most performance objectives can be met only by carefully planning a database’s design and configuration. For example, you may discover that the insert and I/O performance of a particular table causes a bottleneck. In this case, the best course of action may be to re-create the table on a dedicated segment and partition the table. Changes of this nature are disruptive to a production system; even changing a configuration parameter may require you to restart Adaptive Server.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
