Subject | Index key length limits are very small |
---|---|
Author | fokubitch |
Post date | 2002-10-05T17:50:01Z |
Hi,
I found that there is a limit of 84 characters on index key length when using PXW_CSY collation.
For compound index, it looks like total length of all columns together cannot exceed 66 charactes!!! When I exceed it, I get this error:
unsuccessful metadata update
-key size exceeds implementation restriction for index "...."
or sometimes this:
unsuccessful metadata update
-key size too big for index "...."
I need to index a bit longer field! Why is this limit so small?
Can I increase it?
Jan
I found that there is a limit of 84 characters on index key length when using PXW_CSY collation.
For compound index, it looks like total length of all columns together cannot exceed 66 charactes!!! When I exceed it, I get this error:
unsuccessful metadata update
-key size exceeds implementation restriction for index "...."
or sometimes this:
unsuccessful metadata update
-key size too big for index "...."
I need to index a bit longer field! Why is this limit so small?
Can I increase it?
Jan