Creating a Sybase nonclustered index

Non-clustered indexes are used to simulate a clustered index. Use these when you already have a clustered index, but you want another index of that type. Nonclustered indexes can not be created on text or image datatypes. You can have no more than 249 nonclustered indexes on one table.

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

1. To create a nonclustered index, type:

           Create nonclustered 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:

           (

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).

Last updated: 1997/06/23 21:48:02 UT
URL: http://www.nmt.edu/tcc/help/db/sybase/nonclustered.html