Unlike most traditional relational database management systems, Sybase IQ encourages heavy indexing of columns in a database. Additional indexes usually improve query performance and usually do not reduce load performance.
Depending on site-specific issues such as limits on the available load time and the actual queries in the database, you may want to add or remove indexes from the create index script file \Data \RAP_Index\indexes_rap.sql. For detailed information on IQ indexes, refer to the Sybase IQ product documentation.
Before loading the sample data, run the SQL script \Data \RAP_Index\indexes_rap.sql in Interactive SQL Java to create the Sybase IQ indexes. See “Executing the DDL script” for details on running a script in Interactive SQL Java.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
