Creating database objects  Loading the sample data

Chapter 2: Repository Database Setup

Indexes in the IQ database

The RAP data model includes only those indexes that support the sample queries. Statements needed to create these indexes appear in the DDL scripts generated from the RAP IQ data model. Consequently, the indexes supplied with the model will be created automatically when you run the corresponding DDL scripts (see above).

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 RAP IQ data model. For detailed information on IQ indexes, refer to the Sybase IQ product documentation.





Copyright © 2005. Sybase Inc. All rights reserved. Loading the sample data

View this book as PDF