Achieving Performance Goals

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 SAP ASE.