Renato Cramer wrote:
The text following is in doc usermansapdb_eng.pdf page 101:

B* Trees for Table with LONG Columns 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.


Anybody can explicate me what is short LONG e long LONG?

Normally, each LONGs is stored in it's own B* tree. But R/3 uses LONG columns for not so very long strings, as earlier releases had an upper limit of 255 on VARCHARs. Using one B* tree for each of these 'short' LONGs was too inefficient, so these values are stored in one B* tree per table.


Daniel Dittmar

--
Daniel Dittmar
SAP Labs Berlin
[EMAIL PROTECTED]



--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to