Glossary
index
An index is a table that contains the contents of the key fields.
key
A key is the field or fields that the table is indexed on.
keyed storage structure
A keyed storage structure is a storage structure in which data is arranged according to one or more fields in the table. Such an arrangement provides fast access to a particular row or set of rows.
QEP
Query execution plan
rule
A rule is a user-defined mechanism that invokes a database procedure whenever the database changes in a specified way, for example by insert, update, or delete.
secondary index
A secondary index is a table that contains the contents of additional key fields besides those contained in the index.
storage structure
A storage structure is the way data is arranged in a table and affects how the data is accessed.