467,926 Members | 1,521 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,926 developers. It's quick & easy.

Is there a restriction for an index creation?

Anybody knows a restriction for an index creation on a text column?
How deep can an index for a text go?

Somebody told me that a MySQL-Index has a restriction on 255 strings!
And DB2? Is there ever a restriction?

Thanks
Markus
Nov 12 '05 #1
  • viewed: 1334
Share:
1 Reply
The SQL Limits manual says 1024 bytes. It's probably not a good idea to
create an index on such a large, unique field, though. You'll probably have
more luck with the DB2 Text Extender. It's similar to Microsoft SQL's
Full-text search.

--
**Amy**

"Markus Keuthmann" <ma****@keuthmann.de> wrote in message
news:98**************************@posting.google.c om...
Anybody knows a restriction for an index creation on a text column?
How deep can an index for a text go?

Somebody told me that a MySQL-Index has a restriction on 255 strings!
And DB2? Is there ever a restriction?

Thanks
Markus

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Guy Deprez | last post: by
14 posts views Thread by Sean C. | last post: by
1 post views Thread by chettiar | last post: by
1 post views Thread by Ed | last post: by
5 posts views Thread by bclark76 | last post: by
2 posts views Thread by db2udbgirl | last post: by
1 post views Thread by Picaso.Leonardo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.