Next / Previous / Index / ITC Help System / Publications / Site map / NM Tech homepage

Types of Sybase index

Tech Computer Center logo

SQL Server supports two types of indexes:

Clustered indexes allow faster searches than non-clustered indexes. Clustered indexes are often called the primary key of the table. If you don't specify which type of index you want, it will be a non-clustered index by default.

There are a lot of options for creating an index, but the most commonly used one is unique. Both clustered and non-clustered indexes can be unique. A unique index prohibits duplicate values in the column that the index is on. For example, every credit card has a different number, so you could create a unique index based on credit card numbers.

An index can be created that based on multiple columns; this is known as a composite index. For example, you might want to create an index for a table based on zip code and city name.


Next: Creating a Sybase clustered index
See also: Indexing Sybase tables
Site map
Index: Keyword index to help pages
Help: New Mexico Tech Information Technology and Communications: Help System
ITC Publications
To report a problem: File a ticket
Send mail to the User consultant on duty or call them at 575-835-5437
Home: About New Mexico Tech

Maintained by John Shipman, john@nmt.edu; original by Steve Anderson
Last updated: 1997/06/25 19:44:31 UT
URL: http://www.nmt.edu/tcc/help/db/sybase/index_types.html
QR two-dimensional bar code