Filter
Top Products
CHAPTER 4 Adaptive Server IQ Indexes
139
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-name
option 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: