Creating a Sybase clustered index

Use a clustered index when you want the physical order of a table to match the index. They cannot be created on text or image datatypes. Each table can only have one clustered index.

At the end of each command press the space-bar or press enter before continuing the next step.

1. To create a clustered index, type:

            create clustered index

2. Type the name for the index.
3. Type:

           on

4. Type the name of the table you are creating an index on.
5. Type:

   a
           (

6. Type the column name you want to create the index on.
7. Type:

           )

8. Type:

           go

9. Press Enter.

If everything goes well, you see the database prompt (a period, the name of the database you are using, another period, the number one and then the greater than symbol).

Maintained by John Shipman, john@nmt.edu; original by Steve Anderson Last updated: 1997/06/23 21:43:34 UT URL: http://www.nmt.edu/tcc/help/db/sybase/clustered.html