Sybase 12.4.2 manual Scheduling data definition tasks, 102, To set up an IQ database

Building Your Adaptive Server IQ Databases

Multiplex users: The following steps are for creating a non-multiplexdatabase. To create a multiplex database, see the Adaptive Server IQ Multiplex User’s Guide .

❖To set up an IQ database:

1Install and configure Adaptive Server IQ.

This step creates the database server and the asiqdemo database, and allows you to create your first database when you have no other database to connect to. See the Adaptive Server IQ Installation and Configuration Guide for your platform for details.

2Create an IQ database.

This step creates both the IQ Store and the Catalog Store. Use the CREATE DATABASE statement or the Sybase Central Create Database Wizard. See “Working with databases” on page 106.

3Create the tables in your IQ database.

Use the CREATE TABLE statement or the Sybase Central table editor. See “Working with tables” on page 118

4Create indexes for the tables.

Use the CREATE INDEX statement or the Sybase Central Index Wizard. You can also create certain indexes automatically when you create your tables. See Chapter 4, “Adaptive Server IQ Indexes.”

5Load data into the tables.

Use the LOAD TABLE statement to bulk load data from files, or use the INSERT statement to extract rows of data from an existing database. See Chapter 5, “Moving Data In and Out of Databases.”.

6Create join indexes as needed, to improve performance of queries that join data from multiple tables.

To create a join index, use the CREATE JOIN INDEX statement, or the Sybase Central Add JoinIndex Wizard. See Chapter 4, “Adaptive Server IQ Indexes.”

Scheduling data definition tasks

Once the database exists and other users have access to it, follow these guidelines when you need to perform additional data definition operations, such as adding or modifying tables or indexes.

102