Sybase 12.4.2 manual Creating an index with Sybase Central, Creating indexes concurrently, 139

CHAPTER 4 Adaptive Server IQ Indexes

You can use the keywords BEGIN PARALLEL IQ and END PARALLEL IQ to delimit any number of CREATE INDEX statements that you want to execute as a group at the same time. These keywords can only be used when creating indexes on IQ tables, not temporary tables or Adaptive Server Anywhere tables. Note that, if one of these CREATE INDEX statements fails, all of them roll back. For more information, see the Adaptive Server IQ Reference Manual.

Note You cannot place an index in a particular dbspace. Adaptive Server IQ always places an index in the same type of dbspace (IQ Store or Temporary Store) as its table. When you load the index, the data is spread across any database files of that type with room available. The dbspace-nameoption of CREATE INDEX is ignored for IQ indexes, and is provided for compatibility with Adaptive Server Anywhere.

Creating an index with Sybase Central

To create a column index using Sybase Central, follow these steps.

❖To create an index with Sybase Central:

1 Connect to the database.

2 Select the table in which the column appears.

3 Open the Indexes folder.

4 Double-click the Add Index icon, enter a name for the index, and click Next.

5 Select an index type. A High Group is created if you do not click another index type.

6 Optionally set the number of records added before each notification message, and click Next.

7 Select the column you want to index, and click Next.

8 Enter attributes for the index as appropriate, and click Finish to create the index.

Creating indexes concurrently

In some cases, you can create more than one column index at the same time:

139