Database Administrator Guide > Database Administrator Guide > Choosing Storage Structures and Secondary Indexes
Was this helpful?
Choosing Storage Structures and Secondary Indexes
Storage Structure Terminology
A storage structure is a file arrangement providing a way to access data in a database table.
Keyed storage structures provide fast access to a particular row or set of rows in a database table.
A key is the field or fields that the table is indexed on. Specifying this key gives you quick access to the rows you are looking for.
An index contains the contents of the key fields.
A secondary index allows you to specify an additional key.
Last modified date: 11/28/2023