For forums, blogs and more please visit our
Developer Tools Community.
By: Borland Staff
Abstract: The general rule here is that the total length of all fields must not be over 200 bytes.
When I create an index with large varchar/char fields I get an error:
unsuccessful metadata update
-key size too big for index
The maximum length of an index is depends on whether the index is a
multisegment index or not. The total key length is 256, however there
is some overhead, the size of which greatly depends on how many fields
in the index.
For single field indices the general rule is that the max length of an
index fields is ~250 bytes. As you have probably seen this will vary
for the different datatypes (can create an index on a varchar(252)
For multisegment indices the overhead for the index is greatly
increased. The general rule here is that the total length of all fields
must not be over 200 bytes. For example:
create index (v1, i1) will work because the i1 fields is counted as 8
bytes so total is 200 bytes
create index (v1, i1, i2) will work for same reason.
Could not retrieve comments. Please try again later.
Free Developer Edition!
Click here to download a free non-expiring Developer Edition or 30-day trial >
More InterBase Info
InterBase XE7 Product Info
Free Developer Edition download
InterBase on Google+
Follow @InterBase on Twitter
Server Response from: ETNASC01