Creating Indexes on Tables

An index provides quick access to data in a table, based on the values in specified columns. A table can have more than one index. Indexes are transparent to users accessing data from that table; Adaptive Server automatically decides when to use the indexes created for tables.

For information on how you can design indexes to improve performance, see the Performance and Tuning Guide.

How indexes work

Comparing the two ways to create indexes

Guidelines for using indexes

Creating indexes

create index syntax

Indexing more than one column: composite indexes

Using the unique option

Including IDENTITY columns in nonunique indexes

Ascending and descending index-column values

Using fillfactor, max_rows_per_page, and reservepagegap

Using clustered or nonclustered indexes

Creating clustered indexes on segments

Creating clustered indexes on partitioned tables

Specifying index options

Using the ignore_dup_key option

Using the ignore_dup_row and allow_dup_row options

Using the sorted_data option

Using the on segment_name option

Dropping indexes

Determining what indexes exist on a table

Updating statistics about indexes

Updating partition statistics


	Expand Search