Zabach, Elke schrieb:
Thank You for the info.I do not know where your info about keylength is from. But SAP DB as we know it with 7.3 / 7.4 is able to handle keys of up to 1024 bytes --> up to char (511) UNICODE.
I have read the SapDB 7.2 and 7.3 reference manual which states on page 119 sizes for key columns for up to 254 bytes.
You are right, reading carefully, it does not state that longer keys do not exist and on the next page, the document says that all keys together must consume no more than 1024 bytes.
I must have been mislead by the fact that, 2 or 3 years ago, I've have failed to create keys longer than 254 bytes with SapDB.
BTW.
Can You clarify about performance penalties when joining with long characters rather than short integers?
Regards,
Falk
--
Dr. Falk Langhammer
Living Pages Research GmbH
Kolosseumstr. 1a D-80469 Munich, Germany
mailto:[EMAIL PROTECTED] http://www.living-pages.de
Phone +49 (89) 189 207-27 Fax +49 (89) 189 207-29
Mobil +49 (171) 79 39 667
mailto:[EMAIL PROTECTED] (urgent SMS with subject header)
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
