User Guide

SAP AG November 2002
B* Trees for Table with LONG Columns
Long-Felder
K1
K2
K3
10
4000
32000
Longid 1
Longid 2
Longid 3
Primary Table Table for
short LONG Data
Longid 1
Longid 2
L-Data
L-Data
One Table for
Each long LONG Data
K4 568000 Longid 4
L-Data
L-Data
The primary table contains a column of data type LONG. The numerical column defines the
length of the LONG field for each line. There is one B* tree for the primary data, another for
data of type short LONG and multiple B* trees for other data of type long LONG.
The primary table contains a fixed-length reference to the contents of the LONG field in each
row. This reference points uniquely to the storage location of the content of the LONG field,
either as a key to a B* tree (short LONG) or as the table ID [Page
104] of one of the multiple
B* trees (long LONG).
B* Trees for Tables with Secondary Key
An example of B* trees for tables [Page 104] is a B* tree [Page 128] structure in which the
table has primary data and a secondary key [Page
102].
User Manual: SAP DB 105