/ TCC Help System
/ Site map
/ NM Tech homepage
Creating a Sybase composite index
Use a composite index when two columns are logically
connected, such as a city and a zip code. They can not be
created on text or image datatypes.
At the end of each command press the space-bar or press enter
before continuing the next step.
- To create a composite index, type
- Type the name for the index.
- Type the name of the table you are creating an index on.
- Since composite indexes use more than one column, you need to
group them in parenthesis and separate the columns by a comma.
- Type the first column name you want to create the index on.
- For each subsequent column you want to include in the index,
type a comma, then the column name.
- 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).
Next: Example of a Sybase composite index
See also: Indexing Sybase tables
Previous: Example of a Sybase unique index
to help pages
New Mexico Tech Computer Center: Help System
To report a problem: File a ticket
Send mail to the User consultant
on duty or call them at 575-835-5437
About New Mexico Tech
Maintained by John Shipman, email@example.com;
original by Steve Anderson
Last updated: 1997/06/23 22:21:59 UT