Skip to end of metadata
Go to start of metadata

SAP® MaxDB - Primary Keys and Indexes


This section explains the primary key concept of MaxDB and also covers secondary keys (indexes).

Moderator: Birgit Malik

WIKI Space Editor: Thiago Lüttig


B* Tree

In MaxDB databases the data of base tables and indexes are saved as B* trees. This page explains the MaxDB B* tree concept..

Primary Key

Data access should be as efficient as possible. For this purpose, every SAP MaxDB base table has a primary key (also called primary index). This page explains the SAP MaxDB primary key concept.

Index (Secondary Key)

Besides the primary key, users can also define secondary keys, called indexes. This pages gives detailed information about MaxDB indexes.