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.
