One example of B* trees for tables are B* trees for a table that has primary data and data with the data type LONG, as described in the following.
The primary table contains a LONG column. 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 of one of the multiple B* trees (long LONG).