In this example, appropriate index types and
storage locations have been determined for you. Simply follow the
steps to index columns in your table.
In this example, appropriate index types and
storage locations have been determined for you. Simply follow the
steps to index columns in your table.
- Connect to the iqdemo database,
if necessary.
- Right-click Indexes, point to New, choose Index on IQ Table...
- Select the Customers table from
the list, name the new index IQ_IDX_LF_ID,
then click Next.
- Choose the Low Fast option as the Index type, then click
Next.
The default number of records to add before notification is
sufficient for this tutorial. For details about the notify count,
see the System Administration Guide: Volume 1.
- On the dbspace dialog, choose an appropriate dbspace
to store the index. For this tutorial, choose iq_main,
then click Next.
- On the Columns screen, select the ID column
and click Add, then Next.
- Type the comment Low Fast index for
id column in the Comment box and click Finish
to create the index. The Indexes container is updated with the new
index.
- Now add a Low Fast index to the State column, using
steps 3 through 7.
Note: - The remaining columns in the table do not require any of the
optional indexes. The default storage structures are sufficient.
- You can use the CREATE INDEX command instead
of Sybase Central to create column indexes if you prefer. For syntax,
see Reference: Statements and Options > CREATE INDEX statement.