Several command-line options can affect database server performance. Most of the options described in this section control resources for operations on the IQ store, which can have a major impact on performance. Options that affect only the resources available for operations on the catalog store may have a minor impact on overall performance. If you need to specify options that affect the catalog store only, see Chapter 2, “Database Options,” in Reference: Statements and Options for more information.
Performance tuning suggestions are given throughout this guide. See Performance and Tuning Guide for a full discussion of how Sybase IQ uses memory, disk, and processors, the effect of user connections on resource use, and options you can set to control resource use.
