The number of concurrent users of a Sybase IQ database, the queries they run, and the processing threads and memory available to them, can have a dramatic impact on performance, memory use, and disk I/O. Sybase IQ provides several options for adjusting resource use to accommodate varying numbers of users and types of queries. These may be:
SET OPTION command options that affect only the current database.
Command-line options that affect an entire database server.
Connection parameters that affect the current connection only.
For more information on all of these options, including parameters, when the options take effect, and whether you can set them for both a single connection and the PUBLIC group, see the Reference: Statements and Options.
For information specific to optimizing tables, see “Optimizing storage and query performance,” Chapter 5, “Working with Database Objects” of the System Administration Guide: Volume 1.
