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 Series: Locking and Concurrency Control. For information about creating and managing partitioned indexes, see Chapter 10, “Partitioning Tables and Indexes.”
