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. For information about creating and managing partitioned indexes, see Chapter 10, “Partitioning Tables and Indexes.”
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
