Creating an IQ database is part of a larger setup process that begins with installation and ends when your database is available to users. This section summarizes the steps in setting up an IQ database and the objects in it.
Install and configure Sybase 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 Sybase IQ Installation and Configuration Guide for your platform for details.
Create an IQ database.
This step creates both the IQ Store and the Catalog Store.
To use multiplex capability, you must create your database with the Create Database wizard in Sybase Central. For details see “Using Sybase Central to create an IQ database”.
If you don’t require multiplex capability, you may use either Sybase Central or the CREATE DATABASE statement. For CREATE DATABASE instructions, see “Creating a database with SQL”.
Create the tables in your IQ database.
Use the CREATE TABLE statement or the Sybase Central table editor. See “Working with tables”
Create 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 6, “Using Sybase IQ Indexes.”
Load 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 7, “Moving Data In and Out of Databases.”.
Create 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 Join Index Wizard. See Chapter 6, “Using Sybase IQ Indexes.”
Setting up an IQ database