Database Administrator Guide > Database Administrator Guide > Choosing Storage Structures and Secondary Indexes
Was this helpful?
Choosing Storage Structures and Secondary Indexes
 
Storage Structure Terminology
Storage Structure and Performance
Types of Storage Structures
Default Storage Structure of New Tables
Heap Storage Structure
Hash Storage Structure
ISAM Storage Structure
B-tree Storage Structure
ISAM or B-tree?
Storage Structure Comparison Summary
Keys
Secondary Indexes
Tids
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: 08/28/2024