The first step in tuning Sybase IQ performance is to look at your environment. You have various options:
Use system monitoring tools (each system and site has different tools in place).
Use one of the stored procedures that displays information about Sybase IQ. See the next section for more information.
Determine appropriateness of index types. See Chapter 6, “Using Sybase IQ Indexes” in Sybase IQ System Administration Guide for more information about choosing index types.
For on-screen information, look at your insert and delete notification messages. Chapter 7, “Moving Data In and Out of Databases” in Sybase IQ System Administration Guide gives more information about these messages.
Look at the Sybase IQ message file, called dbname.iqmsg by default.
Use the performance monitor in Sybase Central.
Use procedure profiling to track execution times for stored procedures, functions, and events
