Creating an index with Sybase Central

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

StepsCreating 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(s) you want to index, and click Next.

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